Human_doing
Board Regular
- Joined
- Feb 16, 2011
- Messages
- 137
Hi all,
I am putting together a SQL query based on a column 'frm_end_date' using the Excel query wizard. What I'm looking to do is only include rows where frm_end date is before today's date i.e. the column date is overdue. Can this be done in the query wizard? There are two drop downs for each 'only include rows where' option so do I need to select 'is less than' for option one? And if so, what should be put in the second drop down?
Also I would like the date as purely DD/MM/YYYY rather than with a 00:00 timestamp if possible,
Many thanks in advance for any help
I am putting together a SQL query based on a column 'frm_end_date' using the Excel query wizard. What I'm looking to do is only include rows where frm_end date is before today's date i.e. the column date is overdue. Can this be done in the query wizard? There are two drop downs for each 'only include rows where' option so do I need to select 'is less than' for option one? And if so, what should be put in the second drop down?
Also I would like the date as purely DD/MM/YYYY rather than with a 00:00 timestamp if possible,
Many thanks in advance for any help
Last edited:
