Datetime formula logic

[ShreyaSharma]

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

[Goppi · Accepted solution]

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.

[ShreyaSharma]

Hi @Goppi 

I want the date in below format..

mm-dd-yyyy

[Goppi]

converted data type to string and formatted the dates.

you are welcome

goppi