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
10 replies
Subscribers
6 subscribers
Views
3237 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Process
Hi you all, I need to convert the following string (type text) into a en_
Giobis
over 11 years ago
Hi you all,
I need to convert the following string (type text) into a en_US date format.
In a process I used a XOR for manage the locale of the initiator. If locale <> en_US i don't touch the string, but if the locale = en_US I need to convert all date in en format.
This is the array:
", , , , 26/06/13 12:04, 26/06/13 11:55, , , , , , , , "
I using this doforeach :
doforeach("pr_checkStringDateSpaceInArrayList",split(ri!date,", "))
and this Rule (pr_checkStringDateSpaceInArrayList) :
if(ri!date=" ",ri!date, datetext(userdatevalue(index(split(ri!date," "),1,"ERROR 1")),"MM/dd/yy")&" "&index(split(ri!date," "),2,"ERROR 2"))
The problem is that I use "26/06/13 12:04, 26/06/13 11:55" its works but with the previous array doesn't works.
Any suggestion for me?
Thanks a lot...
OriginalPostID-72276
OriginalPostID-72276
Discussion posts and replies are publicly visible
Parents
0
Diana Chavez
Appian Employee
over 11 years ago
You can try using timevalue(right(ri!dateText,8)) and use the date 26/06/13 10:30 PM, this actually returns the time stamp as expected.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Diana Chavez
Appian Employee
over 11 years ago
You can try using timevalue(right(ri!dateText,8)) and use the date 26/06/13 10:30 PM, this actually returns the time stamp as expected.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data