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
+1
person also asked this
people also asked this
Replies
2 replies
Subscribers
7 subscribers
Views
1683 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
todate() function behaviour
kalpanap
over 7 years ago
Hi,
I had faced a scenario when working on todate function.
todate("15-coversion-2015") gave output as 10/19/1618.
todate("15-czurich-2015") gave output as 10/19/1618.
But, the below stuff which is also some junk is expected to give same output as above but gave the below output:
todate("15-madh-2015") -> 5/15/2015,
todate("15-junk-2015") -> 6/15/2015.
Please clarify if the above is expected behaviour. Thanks for your inputs.
OriginalPostID-264637
Discussion posts and replies are publicly visible
0
Ashvin Kapur
over 7 years ago
Kalpana, what is the use case here? I'm not sure that I understand what you're asking. Granted, I understand the confusion with multiple seemingly random text strings returning different outputs, but maybe if you explain why this is an issue to your solution, we will be able to provide you with alternative approaches to achieve the business value
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Raj Yadla
over 7 years ago
usage of text(ri!date,"dd-MMM-YYYY") instead of todate(). Can be helpful here
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel