Alteryx Designer Discussions

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

Datetime formula logic

8 - Asteroid

Hi,

 

Can anyone help me how to get below two 

 

1. First day of every month----Say I run the Alteryx process on 5th Oct So it should get 01-10-2020 on Period column and 31-11-2020 as expected Close Date on ECD column

 

Many thanks

Shreya

 

7 - Meteor

not having seen any sample workflow i made the assumption you want to add those dates to some sort of record. if not let me know.

 

 

8 - Asteroid

Hi @Goppi 

 

I want the date in below format..

 

mm-dd-yyyy

7 - Meteor

converted data type to string and formatted the dates.

 

you are welcome

goppi

Labels