I have a table with a date field. The format is "01-Jan-03". How can I query the table for a particular month, say all January records?
Is it difficult? Do I need to create a dummy field equal to the date field but in string format? If so how do I do that? I can tell the user to input two date ranges but it seems rather long-winded.
Thank you.
Is it difficult? Do I need to create a dummy field equal to the date field but in string format? If so how do I do that? I can tell the user to input two date ranges but it seems rather long-winded.
Thank you.