Creating first day of month column based on existing date column

[carterfleming]

I'm trying to replicate this Excel formula in Designer: =date(year(column A),month(column A),1).

I want a new column to show the first day of the month that the existing column's date falls in. See screenshot for example of desired output.

[DataNath · Accepted solution]

How does this look @carterfleming? If your Date is actually in Alteryx-ready format then you won't need the DateTimeParse() part of the expression:

DateTimeFormat(DateTimeTrim(DateTimeParse([Date],'%m/%d/%Y'),'firstofmonth'),'%m/%d/%Y')

[carterfleming]

That worked! Thanks