Search results

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...

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...