Hi, Can anybody help me? How can I convert a datetime in this format &

luanab over 10 years ago

Hi,
Can anybody help me?
How can I convert a datetime in this format "mm/dd/yyyy 5:00 PM" into "yyyy-mm-dd 00:00:00.000"...

Discussion posts and replies are publicly visible

Parents

0 matthew.shutt
Appian Employee
over 10 years ago

Have you tried the text() function? For example: =text(now(),"yyyy-mm-dd hh:mm:ss")
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 matthew.shutt
Appian Employee
over 10 years ago

Have you tried the text() function? For example: =text(now(),"yyyy-mm-dd hh:mm:ss")
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data