Alert: There is a planned Community maintenance outage October 16th from approximately 10 - 11 PM PST. During this time the Alteryx Community will be inaccessible. Thank you for your understanding!
community Alteryx IO Mission Control
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Close Date

BuchtaA
6 - Meteoroid
‎09-21-2020 03:22 PM

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.

Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

1 REPLY 1
JWS
Alteryx Alumni (Retired)
‎09-21-2020 03:37 PM

@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")

 

JWS_0-1600727831786.png

 

Close Date.yxmd
Reply
Labels