Recent content by timmi30

Sorry Hi, Sorry I got it, just a stupid mistake! Thanks anyway!

Hi Is it possible to have a query something like this: SELECT * FROM availablity WHERE DATEDIFF(day, start_date, enddate) < 7; I know this statement doesn't work, but i hope it illustrates what i am trying to acheive. I want to select records where the difference between the start and end...

Thanks Doc Man, Times are not relevant assume entire day is used! Does this make a difference. Based on your suggestion what would be the SQL construct? Thanks in advance!

No, I am trying return dates availiable dates that aren't being overlapped by unavailable dates. An avaiable date has a yes in the 4th column, unavailable has no. So in the example records 2 and 3 the dates overlap one another, in this instance i do not want the record returned when this...

Hi Everyone! I am desperatly trying to write a query / view that will show available holiday dates, however i am a bit stuck and was wondering if someone kind would help me out. Table Design: id (autonumber) start_date (datetime) end_date (datetime) available (yes / no) Example Data: #1...