Convert text to date/datetime

Certified Associate Developer

over 7 years ago

Is there a function or rule to convert a piece of text to date or datetime? For e.g. '2017-01-07 19:09:29'. Essentially, I'm looking for the opposite of fn!text which will accept a piece of text and format as input.

Discussion posts and replies are publicly visible

0 vinitl522
A Score Level 2
over 7 years ago

Hello Vishal,
You can save the below expression in a rule and then convert the text to date time value:

=userdatetime(tointeger(left(ri!txtDate,4)),tointeger(extract(ri!txtDate,"-","-")[1]),tointeger(right(extract(ri!txtDate,"-"," ")[1],2)),tointeger(extract(ri!txtDate," ",":")[1]),tointeger(extract(ri!txtDate,":",":")[1]),tointeger(right(ri!txtDate,2)))
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Dylan Freadhoff
Appian Employee
over 2 years ago

Use the value function. See docs.appian.com/.../fnc_text_value.html
Cancel
Vote Up -1 Vote Down

Sign in to reply

Verify Answer

Cancel