
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Aug 30, 2022 09:39 AM
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
Solved! Go to Solution.
1 Solution
Accepted Solutions
Solved
See Solution in Thread
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Aug 30, 2022 09:43 AM
Hey @Clare_Fitzpatrick!
Try this:
DATETIME_FORMAT(
DATEADD(
{Date Invoice Raised},
30,
'days'
),
'DD-MMMM-YYYY'
)
Reply
1 Reply 1
Solved
See Solution in Thread
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Aug 30, 2022 09:43 AM
Hey @Clare_Fitzpatrick!
Try this:
DATETIME_FORMAT(
DATEADD(
{Date Invoice Raised},
30,
'days'
),
'DD-MMMM-YYYY'
)
Reply
