Change date format in formula field

[Clare_Fitzpatri]

Hi I would like to change the date format returned in my formula field - I’ve tried using datetime-format but keep getting an error

DATEADD({Date Invoice Raised}, 30,‘day,’) DATETIME_FORMAT(‘DD-MMMM-YYYY’)

thanks
Clare

[Ben_Young1 · Accepted solution]

Hey @Clare_Fitzpatrick!

Try this:

DATETIME_FORMAT(
    DATEADD(
        {Date Invoice Raised},
        30,
        'days'
    ),
    'DD-MMMM-YYYY'
)