Publicado Tue, 20 Aug 2019 12:43:16 GMT por Andreas Ruttkamp
Hello ,
i tried to use this example.

i want to select a date value. can anyone tell me what to do ?
DialogExpressionCondition.Create("DATE", ???, ??? )
i wish to use concret dates such as "01.01.2019"
or dates like "now()-14"



Publicado Tue, 20 Aug 2019 13:13:22 GMT por Craig Heintz GSME
Have you go to this site and see what it may offer you?
Publicado Tue, 20 Aug 2019 13:20:04 GMT por Andreas Ruttkamp
Thank you craig,

i am confused. The lunk i provided in the post above points to this website.
There i can´t find an example for my question. can you give me an hint where to look exactly ?


Publicado Tue, 20 Aug 2019 13:23:48 GMT por Joe Kaufman Bell Laboratories Inc Application Development Manager
Judging by the literals used in URL integration queries (and just tested using a dialog query), it looks like dates need to be of the format:

"YYYY-MM-DD", as in, "2019-08-01" for August 1, 2019.

You pass the date value in as a string formatted in that way. For DateTime values, you use:

"YYYY-MM-DD HH:mm:ss", as in, "2019-08-09 17:32:39".

Be aware that DateTime fields are always stored with UTC time. That goes for system fields as well as user-defined fields.

Good luck,
Joe Kaufman

You must be signed in to post in this forum.