Friday, August 5, 2011

Compare Date with Current Date in Access as a back End database

You have to put # in place of ' while writing a querry.

For example

SELECT * FROM Student WHERE dateofJoining >

#"+DateTime.Now+"#;

but if you are working with SQL then You can write

SELECT * FROM Student WHERE dateofJoining >

'"+DateTime.Now+"';

0 comments:

Post a Comment