any substitute for now() and today() function in appian

6 replies
15 views

how can we get today date with time instead of now() function.

Brainy

If your requirement is to show "status age in days" as you mentioned in your original thread, (and i'm unsure why this required the creation of a new thread when it's essentially the same topic, but too late for that now), you should just be storing the original date(time) in question, then calculating the "age" at display time. This would be far, far easier than trying to figure out a way to get an "age" value coming from the DB in such a way that it updates by itself in real-time.

The Expression Guru

stefanhelzle0001

Brainy

No. But why do you want to avoid it?

H

himanshus0002Author

Known Participant

actually, stefan custom record field does not support now function and i have written logic where i need now() function for value in custom record field

stefanhelzle0001

Brainy

community.appian.com/.../95073

peter.lewis

Employee

I think you'll have to provide more context - is now() not returining what you need? Can you take the result of now() or today() and manipulate it to get what you want?

mikes0011Answer

Brainy

If your requirement is to show "status age in days" as you mentioned in your original thread, (and i'm unsure why this required the creation of a new thread when it's essentially the same topic, but too late for that now), you should just be storing the original date(time) in question, then calculating the "age" at display time. This would be far, far easier than trying to figure out a way to get an "age" value coming from the DB in such a way that it updates by itself in real-time.

The Expression Guru

Sign up

Login with SSO

Login to the community

Login with SSO