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
Solved! Go to Solution.
Hi @HULK , you need the formula:
datetimeformat(datetimetrim(datetimetoday(),'month'),'%Y%m%d')
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')