Digit to days in month

[terrellchong]

I have a column with with number from range 1 to 12 as below.

1
2
3
4
5
6
7
8
9
10
11
12

And we all know that 1 is January and in January there is 31 days.

I know that I can do it the dumb way, which is using formula and using IF function, but i just want to explore if there is any other ways to do this.

[IraWatt · Accepted solution]

Hey @terrellchong,

Here is one workflow which can do this:

Any questions or issues please ask :)
HTH!
Ira

[PhilipMannering]

Here's another way,

datetimeday(datetimetrim(regex_replace(datetimetoday(), '-\d\d-', '-'+padleft(tostring([1]),2,'0')+'-'), 'lastofmonth'))

Actually, I think it's pretty similar.