Skip to main content
New Participant
Sep 25, 2022 6:32 PM UTC
Question

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

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
    Brainy
    Sep 25, 2022 7:05 PM UTC

    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
    Brainy
    Sep 25, 2022 9:08 PM UTC

    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