Solved

Change date format in formula field

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

Best answer by Ben_Young1

Hey @Clare_Fitzpatrick!

Try this:

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

+22

Hey @Clare_Fitzpatrick!

Try this:

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

Sign up