Question

Enter and display datetime with seconds?

Forum|Forum|4 years ago
July 19, 2022
5 replies
0 views

How can I have the user enter a datetime including seconds in Appian? The date & time input control does not allow me to enter seconds (it clears the entire date/time value when I try)

How can I display the datetime back to the user with the seconds? I do not see any display formatting for the date & time control.

It seems odd that this is not built-in... or if it is then I'm odd because I cannot find it.

harshitb6843

To display the date time with seconds, you can use text() function. But for capturing, can you tell me the use case you are trying to solve/work on where you need to capture even the seconds that too by letting the user input it?

S

stevenh6272Author

I do not have a particular use-case in mind here. I am exploring what Appian can and cannot do compared to another tool to identify any potential issues. Appian is the first tool I have encountered that does not display the full timestamp by default and I was very surprised when it would not even allow me to enter seconds in the datetime control.

D

deepakg681722

Hey, You can use text(now(),"DD/MM/YYYY HH:MM:SS AM/PM"). here now() is your date&Time. Basically, we are using this seconds part to store the value into DB like createdOn or UpdatedOn just to get the latest data based on it.

R

ruwrr0001

[deleted]

mikes0011

Brainy

spam [emoticon:c080f6a5d7fe45f39ff3f8b32fff0ce8]

The Expression Guru

Sign up

Login with SSO

Login to the community

Login with SSO