first of the month

[ntudev]

I need a formula to get me 1st of the month from the previous month. So get the date from column 1 (June 7) and in column 2 (May 1st)

Column 1              Column 2 ( should be)

2022-06-07         2022-05-01

Please help

[IraWatt]

Hey @ntudev,

This formula does this:

DateTimeTrim(DateTimeAdd([Field1],-1, "months"),"firstofmonth")

Any questions or issues please ask :)
HTH!
Ira

[binu_acs]

@ntudev Another way of doing this.

[HomesickSurfer]

Hi @ntudev 

Another approach:

ToDate(DateTimeAdd(DateTimeAdd([OriginalDate],-1,"month"), 1-DateTimeDay(DateTimeAdd([OriginalDate],-1,"month")), "days"))