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.
解決済! 解決策の投稿を見る。
@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")