Notifications
Clear all
Topic starter
Hello all,
I am trying to convert a datetime value into a date, what I have so far is the following pseudocode,
{!fn fnGetDate(timeStamp){
local date = getfield(timeStamp,"/","")
date = date[1] + "/" + date[2] + "/" + date[3]
return date
}}
Does anyone have a working example of this?
Thanks!
Posted : December 1, 2016 7:43 am
Its easier than that, just do this -
ADDDATES(timestamp,"0","0","0")
If it is a valid date (or date time) this will return a 10 digit date, if not it returns an empty string. Very useful.
Posted : December 1, 2016 7:54 am
Topic starter
This is perfect!
Thank you so much!
Posted : December 1, 2016 8:05 am
