Compare Start Date with Current date +1 day
Hi Fidel,
again, its me... ;-) I'm struggling with the boolean...validator. I want to check if a given start date is set to now + 1 day. So, if the ticket is created today and the start date is also set for today then the validator should cast on.
Therefore I tried the following: {10503} > (datePart({00057}, LOCAL) + 1 * {DAY})
Comments (15)
-
repo owner -
reporter Unfortunately none of both works. I use a simple Date Picker, but the data is collected within Service Desk Portal. But that shouldn't make a difference, should it?
To be precisely: the validator always casts on no matter what date I enter.
-
repo owner Do you want to validate that {10503} contains a date value corresponding to tomorrow or later?
-
reporter Yes.
-
reporter Data must be at least one day in the future.
-
repo owner Try this one:
datePart({10503}, USER_LOCAL) > datePart({00057}, USER_LOCAL)
-
reporter Unfortunately still the same behavior. The validation blocks the transition no matter what date is entered.
-
repo owner Are you sure that the transition blocking is not caused by the 2th validation in the transition?
It's very strange. That's a very simple validation. I would like to see the problem in direct. Can we have a Skype video-conference with screen-share? I will be available today since 19:00 to 22:00 UTC, or on Monday from 9:00 UTC. Please, propose a time for the meeting.
-
reporter Yes. Cause if I delete the JWT-validation the ticket is created... :-(
-
repo owner Can we have a Skype video-conference with screen-share? My user is fidel100r.
-
reporter Cool! I will contact you on monday, ok? Have a nice weekend!
-
repo owner I will be available since 9:00 UTC. Please, tell me, approximately, the time you will try to contact me,
-
reporter Hi Fidel,
sorry, I was not at the office yesterday. I will try to reach you now. :-)
-
reporter Hi Fidel,
I send you a contact request. I'm in the office for the whole day until 5 pm. Just give me a short hint when your are ready for a short call.
Thank you Patrick
-
repo owner - changed status to resolved
Solved in the video-conference. The problem was due to a misconfiguration in the input format for the Date Pickers. Was solved restoring the default configuration at JIRA > System > General Configuration > Advanced.
The final validation used was:
datePart({10503}, USER_LOCAL) >= datePart({00057}, USER_LOCAL) + {DAY}
- Log in to comment
Hi Patrick,
Assuming that field {10503} is a Date Picker maybe this should work:
In case it's a Date Time Picker, you should use: