I'm trying to set up a value condition on a date field. I picked from the little calendar icon but it's telling me it needs a valid date format? The calendar yields DD-MM-YY. What format is it looking for?
I'm trying to set up a value condition on a date field. I picked from the little calendar icon but it's telling me it needs a valid date format? The calendar yields DD-MM-YY. What format is it looking for?
Are you trying to do a control on a field? Then use something like this
if valeur <> [13/01/2022] then......
or if valeur <> date$ then......
Here's a screen shot-
John Mitchell OK, my fault that I did see you were in SEI...... I think I have seen this before and am checking some notes I have.
John Mitchell I think it wants yyyy-mm-dd, so even though you got that from the calendar, reformat and try. Also check for spaces.
Darn. That's not either. What happens is SEI displays 01-01-1753 when there isn't a value for the MRP date. Trying to suppress that by changing that occurrence's font color to white.
Neither did I realize that you are in SEI. Try doing "Not between" 1900-01-01 and 2099-12-31 or do less than 1900-01-01
Still giving me the error-
John,
What happens when you TYPE in 2022-02-14, does it switch to 02-14-2022?
What is the format of this field in process designer?
The issue with 1/1/1753 is a separate issue for that I said that you should do less than 1900-01-01.
John,
What happens when you TYPE in 2022-02-14, does it switch to 02-14-2022?
What is the format of this field in process designer?
The issue with 1/1/1753 is a separate issue for that I said that you should do less than 1900-01-01.
Yeah - it switches over to 02-14-2022 which is the format in the process design. Yeah - so I just used an arbitrary date. For the format condition I'd use < 1900-01-01.
*Community Hub is the new name for Sage City