Function field (glidefunction) based on approved_end_date returns an extra day

DanielIsaiVela
Tera Contributor

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