Changing date day value to 01

Question

Hey guys, i would need some help with a date problem i'm having, its something like, my date format is like "yyyy-mm-dd" format, and i would need a solution that allows me to get the day of this date value and change it to "01" independent of the day it is, so if its day 26, 25 or even 13, the solution will change it to 01.

Someone knows how to do it?

Luke_C · Accepted Answer

Hi @TormentMaker

Using a formula tool, put datetimetrim([Field],'firstofmonth'). Replace Field with your column name. This assumes the field is already stored as a date.

atcodedog05 · Accepted Answer

Hi @TormentMaker

You can use formula like below

DateTimeFormat([Date],"%Y-%m-01")

Where day is fixed and set to 01

Hope this helps 🙂