Skip to main content
A
abduls0003
September 25, 2022
Question

convert datetime filed to json format "2022-08-15 00:00:00.0"

  • September 25, 2022
  • 2 replies
  • 0 views

Hi all

i have a requirement that user entered date time field to json format  "2022-08-15 00:00:00.0" how to convert it , from appian end,

i tried text function - text(now(),"yyyy-mm-dd HH:MM:SS")  but it returns current date time it should be user entered.

Thanks In Advance

    2 replies

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    September 25, 2022

    Can you provide a code snippet of what you a re currently working on?

    Check these examples for how to store a user entered value in a different format: https://docs.appian.com/suite/help/22.3/fnc_evaluation_save.html#examples

    mikes0011
    mikes0011
    Brainy
    September 25, 2022

    The simple answer here is that when you call the text() function, you wouldn't pass in "now()" as in your example if you're wanting to convert a user-entered datetime value to that format - you would need to actually pass the user-entered value itself.

    The Expression Guru
    Terms & ConditionsAccessibility statement