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!
Solved! Go to Solution.
Use this formula: DateTimeAdd(DateTimeTrim(DateTimeToday(),'month'),-1,'day')
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
Thanks,
How to convert EndofLastMonth to "28-Feb-23" afterwards?