First Day of the month in YYYYMMDD format

[HULK]

Hello 

I have one of the filed called Start date where I need to input 1st date of the month in YYYYDDMM format, can you help me know how can this be achieved using date time function using formula tool

Thanks
Nikhil

[FinnCharlton · Accepted solution]

Hi @HULK , you need the formula:

datetimeformat(datetimetrim(datetimetoday(),'month'),'%Y%m%d')

[DataNath · Accepted solution]

Hey @HULK, there's a function that will pull the first day of the current month. Just need to wrap that in DateTimeFormat() to get the desired format i.e. without the hyphens:

DateTimeFormat(DateTimeFirstOfMonth(),'%Y%d%m')