Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
4 replies
Subscribers
7 subscribers
Views
2167 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
AI and Rules
Hi I have date which is in text format, sample date is "2013-04-02 00:00:00
Sumeet Khare
over 11 years ago
Hi I have date which is in text format, sample date is "2013-04-02 00:00:00.000". let me know how to convert it into date as todate & todateTime are not working on this format....
OriginalPostID-75223
OriginalPostID-75223
Discussion posts and replies are publicly visible
Parents
0
Mike Schmitt
Certified Lead Developer
over 11 years ago
For whatever reason, the ISO 8601 date format (YYYY-MM-DD) is not supported by the todate() function (or by the date picker); in your case you can try splitting the date and time apart using the split() function or similar, then following the previous commentor's suggestion, call the date() function after splitting the date portion on the dash ("-") character.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Mike Schmitt
Certified Lead Developer
over 11 years ago
For whatever reason, the ISO 8601 date format (YYYY-MM-DD) is not supported by the todate() function (or by the date picker); in your case you can try splitting the date and time apart using the split() function or similar, then following the previous commentor's suggestion, call the date() function after splitting the date portion on the dash ("-") character.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data