Share feedback, ideas and get community help

Updated last year

Hello Guys,

At a glance
The community member is using a Date input to collect several dates and wants to create rules to limit upcoming dates based on dates already entered, which are stored in variables. The community member tested putting the dates manually and it worked, but when using the variable dates, it didn't work. The issue seems to be related to the date format, as the field expects YYYY-MM-DD format, but the community member was using DD/MM/YYYY. When the community member tried changing the field to store in YYYY-MM-DD format, they received an error message about using "yyyy" instead of "YYYY". There is no explicitly marked answer in the comments.
Useful resources
I need some help.
I'm using a Date input to collect several dates, but I wanted to create some rules taking information from dates already entered (which I stored in variables) to limit upcoming dates. Example: I have a field that I call Shipping_Date and another that is Receipt_Date, when the person enters the Receipt_Date, it can never be before the Shipping_Date.

I tested putting the dates manually and everything works fine, but when I use the variable dates, it doesn't work. From what I gather, it's related to how I'm storing the date. By default I'm using DD/MM/YYYY, but this field expects to receive YYYY-MM-DD

I tried changing my field to store in this format, but when I did that I got this error:

{
"status": 500,
"body": {
"message": "Use yyyy instead of YYYY (in YYYY-MM-DD) for formatting years to the input Mon Jan 01 2024 12:00:00 GMT+0000 (Coordinated Universal Time); see: https://github.com/date-fns/date-fns/blob/master/docs/unicodeTokens.md",
"code": "INTERNAL_SERVER_ERROR"
}
}

Any way how to resolve this?

Note: I know you won't be able to see it, but I created a flow with lots of details / checks including validations and data search (attachment)

Thank you

Eric
Attachment
Flux.jpg
V
e
2 comments
Like this?
The variable is a Date, it's a number. The format is only used to display.
Attachments
image.png
image.png
@Vilela™ That would be what you showed, I'm doing it this way, putting validation in this field option so as not to let the person choose a previous date, but it only works if the date is in the format YYYY-MM-DD
Attachment
Flux.jpg
Add a reply
Sign up and join the conversation on Discord