Help

Formatting date

Topic Labels: Formulas
930 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Thomas_Price
4 - Data Explorer
4 - Data Explorer

I know this is trivial and been answered before, however looking through other topics I still haven’t been able to solve this myself and my business needs it resolved swiftly.

Formula designed to generate a date 14 days before “Dates Agreed”, I want the outputs formatted in the European fashion (DD/MM/YYYY) and without the time tacked on.

Current formula;
IF({Dates agreed},DATEADD({Dates agreed}, -14, “days”))

Thanks

1 Reply 1

Hey @Thomas_Price!
Welcome to the forums!

This should be what you’re looking for:

IF(
    {Dates agreed},
    DATETIME_FORMAT(
        DATEADD(
            {Dates agreed},
            -14,
            'days'
        ),
        'DD/MM/YYYY'
    )
)

Let me know if it throws you an error, but it should be pretty straightforward!
I’m happy to answer any questions you might have about it or help out if you want to keep exploring and adding more in for your workflow.