last day of previous month

[wenyg]

Hi

  How to extract the last day of previous month without any input column?

  For example, as of Feb 9 2023 (today), I want to pull the date like this "31-Jan-23". Thanks!

[willemb]

Use this formula: DateTimeAdd(DateTimeTrim(DateTimeToday(),'month'),-1,'day')

[Felipe_Ribeir0]

Hi @wenyg 

First formula will get the last day of the last month (2023-01-31)

Second formula will transform 2023-01-31 into 31-Jan-23

[wenyg]

Thanks,

   How to convert EndofLastMonth to "28-Feb-23" afterwards?

[Felipe_Ribeir0 · Accepted solution]

Hi @wenyg 

End of current month, right?