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.

[OllieClarke · Accepted solution]

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

[ChrisTX]

Which functions have you tried so far?

Take a look at DateTimeTrim, DateTimeFirstOfMonth, DateTimeLastOfMonth.

Here's a list of all DateTime functions: https://help.alteryx.com/current/designer/datetime-functions

Chris