Skip to main content
H
himanshus0002
May 13, 2022
Solved

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

  • May 13, 2022
  • 6 replies
  • 0 views

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

    Best answer by mikes0011

    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.

    6 replies

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    May 13, 2022

    No. But why do you want to avoid it?

    H
    himanshus0002Author
    May 13, 2022

    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
    stefanhelzle0001
    Brainy
    May 13, 2022

    community.appian.com/.../95073

    peter.lewis
    peter.lewis
    Employee
    May 13, 2022

    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?

      mikes0011
      mikes0011Answer
      Brainy
      May 13, 2022

      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.

        Terms & ConditionsAccessibility statement