How to check selected date is already in database

[DTtechies]

Hello Everyone,

In my app have start date picker and end date picker.

i want to notify to user when start date and end date is already in database.

 my start date is 14th and end date is 16th and submit request. 

then again i select 13th is start date and 15th is end date then i want to notify to user that They have already requested in selected date in between

[JD382 · Accepted solution]

You can filter your data source and see if it returns anything. If it is blank then there is not any overlap. In this example DataSource is your database, StartDate and EndDate are the respective column names in your database.

If(
  !IsBlank(
    Filter(
      DataSource,
      (StartDate >= StartDatePicker.SelectedDate && StartDate <= EndDatePicker.SelectedDate) || (EndDate >= StartDatePicker.SelectedDate && EndDate <= EndDatePicker.SelectedDate)
    )
  ),
  Notify("Date already selected", NotificationType.Error)
)

[DTtechies]

@JD382 

thank for the answer, it is working now.

Thank you

[DTtechies]

Hi @JD382 

your solution is working but i have another problem

if i am taking request from 1st to 5th and try to take a request on 3rd then am i am able to take request.

but in my case a dont want to allow user to take request between date

thanks in advance

[JD382]

You can add another criterion to the filter function.

|| (startdate <= StartDatePicker.SelectedDate && enddate >= EndDatePicker.SelectedDate)

This captures any existing requests that completely encompass the start and end dates that the user picks.

[DTtechies]

Hi @JD382 

i have taken a leave on 21st to 23rd

and trying to take a leave on 21st, then its allow to take a leave, but i dont want to allow 21st date to take a leave