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?

Discussion posts and replies are publicly visible

Parents

0 ashokv
A Score Level 1
over 9 years ago

Hi Joe, you can try using the text() function for the required format..eg:text(month(now()),"00")...will give u 07 instead of 7
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 ashokv
A Score Level 1
over 9 years ago

Hi Joe, you can try using the text() function for the required format..eg:text(month(now()),"00")...will give u 07 instead of 7
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data