Martyn Houghton Posted June 3, 2020 Share Posted June 3, 2020 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 Link to comment Share on other sites More sharing options...
Martyn Houghton Posted June 4, 2020 Author Share Posted June 4, 2020 I have tried using a full format such as 00:00:00 01/07/2020, but still does not evaluate properly. Cheers Martyn Link to comment Share on other sites More sharing options...
Alberto M Posted June 4, 2020 Share Posted June 4, 2020 @Martyn Houghton, did you tried the same format as I (we?) use in the SQL Database Direct? 2020-07-01 2 Link to comment Share on other sites More sharing options...
Martyn Houghton Posted June 4, 2020 Author Share Posted June 4, 2020 @Alberto M I give that format ago. Cheers Martyn Link to comment Share on other sites More sharing options...
Martyn Houghton Posted June 4, 2020 Author Share Posted June 4, 2020 @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 1 Link to comment Share on other sites More sharing options...
Alberto M Posted June 5, 2020 Share Posted June 5, 2020 Glad to help, @Martyn Houghton Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now