Help

Change date format in formula field

Topic Labels: Formulas
Solved
Jump to Solution
88 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Hey @Clare_Fitzpatrick!

Try this:

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

See Solution in Thread

1 Reply 1

Hey @Clare_Fitzpatrick!

Try this:

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