Format calculated date colum

Platform discussions Special workflows & use cases
1

Hi we have created some calculated date fields but now get the long date. Wha’s the formula to add onto the end to fix. I have text(ADD_DAYS({Start Date},{# days},“MMM,DD,YYYY”)) and it returns NaN

2

@amac,

Instead of the TEXT() function use FORMAT_DATE():

FORMAT_DATE(ADD_DAYS({Start Date},{# days},"MMM,DD,YYYY"))

Jim

3

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.