Function field (glidefunction) based on approved_end_date returns an extra day
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11m ago
Hi everyone,
I am facing an issue when configuring a Function Field (glidefunction) on the pm_project table to extract and format the date from the approved_end_date field.
The issue: When applying string manipulation functions (such as substring and concat) to parse the date into a DD-MM-YYYY format, the resulting value always displays one extra day compared to the actual date stored in the original record.
How can I properly structure or handle this function field so that it returns the exact calendar day without adding that extra day?
Thanks in advance for your support!
0 REPLIES 0