Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Change date format in formula field

Topic Labels: Formulas
Solved
Jump to Solution
1238 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'
)