Help

Change date format in formula field

Topic Labels: Formulas
Solved
Jump to Solution
736 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Clare_Fitzpatri
5 - Automation Enthusiast
5 - Automation Enthusiast

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

1 Solution

Accepted Solutions
Ben_Young1
11 - Venus
11 - Venus

Hey @Clare_Fitzpatrick!

Try this:

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

See Solution in Thread

1 Reply 1
Ben_Young1
11 - Venus
11 - Venus

Hey @Clare_Fitzpatrick!

Try this:

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