Conditional formula to replace dates

BautistaC888

Hello,
I have a database with dates (dd/mm/yyyy).
INPUT:

Desired OUTPUT:

I need two conditional formulas:
- if the [start date] is on a month before the [date] month then put the first day of the month of [date] otherwise leave the [start date].
- if the [End date] s on a month before the [date] month then put the last day of the month of [date] otherwise leave the [end date].

Thank you.

date.yxmd

OllieClarke

Hi @BautistaC888 here's how I'd implement that logic:

Personally I'd leave the output as Alteryx formatted dates, but if you need them in mm/dd/yyyy then I've shown how to convert them back.

Hope that's helpful

Ollie

date.yxmd