Format calculated date colum

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


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

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


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