Question

Block dates on the calendar between two days

  • 5 February 2024
  • 5 replies
  • 48 views

Badge +1

Hi, I have two calendars in a form, one date is for the start tag and the other is for the end tag.

These dates are saved in a database, I need that in the next request, if the person chooses those same dates, it does not allow them to do so because they have already been taken.
I tried with a submit rule, but the comparison options it gives me are "is after, is before, is empty, is full", but I need an option like "between dates".

Is it possible to do this another way?

Thank you


5 replies

Badge +8

Hello @Yhaizley RV , you can do it with Formulas:

 

 

Badge +1

Hello, thank you for your help.

But I must not only compare with a date, i have a list of dates that are stored in the database and that when bringing them to nintex are in a collection.

That is to say, if I select the date 03/06/2024 in the form, it must look for me in that collection of dates if it has already been taken or not.

Thank you
 

 

Badge +8

Hello @Yhaizley RV ,

I see the problem.

Because NAC always passes the date at a UTC datetime to SQL, it will be very difficult to implement this directly on a Table based Data Source Variable. So one way I could suggest is to use a SQL Stored Procedure which takes two date strings as input.

You then create a Data Source on the SPROC and a DSV on your Form where you pass in formatted dates and do a test to see if any rows are returned.

 

Userlevel 5
Badge +20

Hi @Yhaizley RV 
Did this response solve your question?

Badge +1

Hello, thank you for all your help
At the moment you gave me the idea of ​​doing this, it wouldn't complete the whole problem but it improves the system

What I did was create a source data that would bring me all the start date and end date that I had stored in the database. 

I converted to string the collection of all the dates of start date and end date that the source data brings me


I had to format the end date and start date of the form to match the collection.
 


Then, create this rule that what it does is compare if the date selected in the form is in the collection of data that it is bringing me


If the rule is completed it shows me this error in the form

 



But now I need the dates between the selected dates to also appear as not possible to take. 

It would be very helpful and easy if there was the between dates option.
 

 

Reply