• State Not Answered
  • Replies 5 replies
  • Subscribers 7 subscribers
  • Views 6892 views
  • Users 0 members are here
Related Discussions
Home » Discussions » AI and Rules

Convert text to date/datetime

VV
Certified Associate Developer

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.

OriginalPostID-212490

OriginalPostID-212490

  Discussion posts and replies are publicly visible

Parents
  • 0
    A Score Level 3
    There is so many different ideas of how a date should look like. It is impossible to create a function that does understand all formats. Just make sure your function does not break if the date is not in the expected format. So it could make sense to store all parts in local vars, validate the values and if everything is correct, then create a date out of it.
Reply
  • 0
    A Score Level 3
    There is so many different ideas of how a date should look like. It is impossible to create a function that does understand all formats. Just make sure your function does not break if the date is not in the expected format. So it could make sense to store all parts in local vars, validate the values and if everything is correct, then create a date out of it.
Children
No Data

© 2024 Appian. All rights reserved.