Menu
How can I retrieve a record based on a Date property? I'm trying:
WHERE Meetings.[MDate] = '16/12/2011'
which is the format I use but I get :
"Data type mismatch in criteria expression"
Problem solved: It should have been:
WHERE Meetings.[MDate] = 16/12/2011
No quotation marks.
597
SELECT Format(Now(), "dd mmmm yyyy"); You can use the Format() function with date values to specify the date format that you want to use for the date. This example query returns the current date in the long date format (01 December 2003).
You can specify the format of the dates in your statements using CONVERT and FORMAT. For example: select convert(varchar(max), DateColumn, 13), format(DateColumn, 'dd-MMM-yyyy')
The access date is listed in Day Month Year format at the end of the citation. For example: Accessed 10 Sept. 2016.
To view items with a date on or before Feb 2, 2012, use the <= operator instead of the < operator. Returns items with a date after Feb 2, 2012. To view items with a date on or after Feb 2, 2012, use the >= operator instead of the > operator. Returns items with a date between Feb 2, 2012 and Feb 4, 2012.
For where clauses use
columnName = #mm/dd/yyyy#
You'll want to use the SQL date format: '#2011-12-16#'
37
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
