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.

Alteryx Screenshot.docx

DataNath

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')

First of month.yxmd