SQL/SSRS Date filter

[andrewhoddie]

Hi all

Hopefully I have posted this in the correct forum.

I am trying to create a report that shows who is off today. I have three fields that show the date_from the date_to and the Duration (in days)

The issue I am having is where someone has taken the full week off for example 12/02/2018 to 16/02/2018 a duration of 5 days but the current date is in between them e.g. 13/02/2018. Is there a way of creating a calculation so that where the date difference between date_from and date_to is equal to the current date than return a true value else a false value?

thanks
Andrew

 

[Kyle123]

Maybe:

SELECT * FROM your_table WHERE GETDATE() BETWEEN date_from and date_to

 

[andrewhoddie]

Thanks very much works a treat