• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Compare date SQL command in Access 2K ?

L

larva

Member
Hi,

How to compare a date in Access 2K ? Like

select * from Name where date_of_birth > '04-Mar-2003 11:22:01';

but the above statement wrong !

Pls help !
 
where are you getting the date from ?? with the time like that it looks like a time variable?!?!

in any case - if you just switch to design view (careful, keep a copy of the sql - cuz access can change it) & type in Mar 04 it will convert to the date of the current year. It will also be between #ash marks.
Sorry but I can never remember the order it puts the 3 2digit pairs 😱

Then just switch back to SQL view.
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top