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
3 replies
Subscribers
8 subscribers
Views
5101 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
AI and Rules
I am looking for a way to validate that a user entered date (in a text field) is
ryanh
over 11 years ago
I am looking for a way to validate that a user entered date (in a text field) is a valid date, or at least reasonably matches the format mm/dd/yyyy. I was unable to find any native Appian expressions/functions that will validate a date format (and the Masking functions aren't allowed on Tempo/Mobile enabled forms).
I was able to find references to the component 'Appian Regular Expression Functions' that has the regexmatch() function. With a little digging online I built an expression that tests a date and returns true for 01/01/1970-12/31/2039 and a false outside that range or formatting. However, it doesn't know the difference for leap years, etc.
=regexmatch("^(?:[1-9]|0[1-9]|1[0-2])/(?:[0-9]|0[1-9]|1[0-9]|2[0-9]|3[0-1])/(?:19[7-9][0-9]|20[0-3][0-9])$",ri!date)
Is there a built in function in Appian to allow server or client side validation of dates to minimize typos? I am not at this time using the SAIL and Tempo functionality?...
OriginalPostID-103408
OriginalPostID-103408
Discussion posts and replies are publicly visible
Parents
0
ryanh
over 11 years ago
...
Ryan
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
ryanh
over 11 years ago
...
Ryan
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data