How to pass current year and Month parameters based on the system date to workflow?

[mark_paul]

Hi All,

How to pass current year and Month parameters based on the system date to workflow?

Thanks,

Mark

[JoeS · Accepted solution]

Hi @mark_paul 

DateTimeNow() within the formula tool will give you the data and seconds.

DateTimeToday() will give you just todays date.

You can then use DateTimeFormat(DateTimeNow(),"myformat") if you need to change the presentation of the date. Alteryx date format is CCYY-MM-DD

Thanks

Joe

[danilang · Accepted solution]

Hi @mark_paul 

DateTimeYear(DateTimeToday()) returns the current year

DateTimeMonth(DateTimeToday()) returns the current month, 1-12

DateTimeFormat(DateTimeToday(),"%B") returns the current month name, October, Change "%B" to "%b" to get the abbreviation, Oct

Dan