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
7 replies
Subscribers
7 subscribers
Views
3586 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
AI and Rules
I need to build a numeric string for a time stamp of exactly YYYYMMDDHHMMSSCCC
joep45
over 9 years ago
I need to build a numeric string for a time stamp of exactly YYYYMMDDHHMMSSCCC
Is there an alternative to using if() statements on everything in order to force 07 for the month of July, 09 for 9am etc
The person who developed the corresponding program showed me the c# code which uses padleft to insert 0s but appian padleft only allows for spaces to be inserted. Is there any other function to save from having 6 if() statements to generate this string?
OriginalPostID-158950
OriginalPostID-158950
Discussion posts and replies are publicly visible
Parents
0
ashish.deshmukh
A Score Level 1
over 9 years ago
Hi Joe, This can be achieved using text function. Try this
text(now(),"ddmmyyyyhhmmss") you can replace now() with your timestamp
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
ashish.deshmukh
A Score Level 1
over 9 years ago
Hi Joe, This can be achieved using text function. Try this
text(now(),"ddmmyyyyhhmmss") you can replace now() with your timestamp
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data