Close Date

[BuchtaA]

Hello all,

I'd like to create a column in my data set titled "Close date." I have created a blank column, and I need the field to be populated with the first day of the current month (ex. 09/01/2020 for September). I'd like to populate it on a monthly basis. Is there a way to do this? I am currently dragging/copying the date in excel after my workflow runs. Please let me know if there is a solution.

[JWS · Accepted solution]

@BuchtaA try the following formula in your formula tool. This will give you the first day of the month based on today's date.

DateTimetrim(DateTimeToday(),"firstofmonth")