Date Fomula

[garretwalters12]

What formula can i use to have the 15h of the previous month for the current year.   ex. 2/15/2019

[MarqueeCrew · Accepted solution]

Left(DateTimeAdd(DateTimeFirstOfMonth(),-1,"Day"),8)+"15"

@garretwalters12 ,

That's last month's 15th.

Cheers,

Mark