Skip to main content

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.

Reply


Terms & Conditions