Solved: Days in a Month - Page 2

TotalSolutions · 03-28-2021 07:38 AM

Please let me now how can I extract the number of days a particular month has. Example If January is selected in a enum which has all months listed, it should show it has 31 days or if April is selected it should show 30 days.

Thanx.

Suvrutt_Gurjar

Somethingl ike below

First Column Type Enum called say [MonthsSelect]

valid If of this column {“January”, February", “February-Leap”, “March”, “April”, …,“Novembrt”, “December”}

Second Column Number type called say [MonthDays]
App formula for [MonthDays]

SWITCH([ MonthsSelect], “January”, 31, “February”, 28, “February-Leap”, 29, “March”, 31,“April”, 30, …,“November”, 30, “December”, 31, 30)

View solution in original post