query? Decision Expression - Date static value entry format

[Martyn Houghton]

I am trying to find details of the format to enter a static date as part of a decision node custom expression. In the example below we want to change the routing in the workflow when a request is logged against a certain service but only do so from the 1st July.

At the moment the custom expression when logged against Service ID 245 is equating as true, even though the date logged is still June.

Is there a specific format the date value needs to be entered as for the date/time condition to work?

Cheers

Martyn

[Martyn Houghton]

I have tried using a full format such as 00:00:00 01/07/2020, but still does not evaluate properly.

Cheers

Martyn

[Alberto M]

@Martyn Houghton, did you tried the same format as I (we?) use in the SQL Database Direct?

2020-07-01

[Martyn Houghton]

@Alberto M

I give that format ago.

Cheers

Martyn

[Martyn Houghton]

@Alberto M

Thanks for the pointer, got it to work with your date format and the timestamp format of 2020-06-04 14:30:00 as well.

Cheers

Martyn

[Alberto M]

Glad to help, @Martyn Houghton