Formatting date

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

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.

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.