how to Compare todays date with oledb date?? please help

Question

hi guys. I need som help here. need to know how i can compare date from database to today´s date. don´t need it to be very exact. just days will work fine in my case. i need days so i can see if its time for transducer calibration. if date < three month or 90 days then should textbox´s change color to red, showing its time for new calibration. thx by the way. I am using visual studio 2008 C#, and Access 2007

Answer 1

Maybe the DateTime.FromAODate method is useful for you.

Answer 2

Have a look at this link

Data type mismatch in criteria expression | Access, OleDb, C#

If i understand correctly from the comment, You can use Date() function to get date today

Something like this

SELECT Table1.Col1, Date() AS Expr1
FROM Table1
WHERE (((Table1.Col1)<Date()));

Answer 3

Perhaps:

SELECT Field, Field 
  FROM Table
 WHERE SomeDate < Date() - 90

Answer 4

Perhaps use the Access Database Engine's temporal functionality e.g. NOW and DATEDIFF():

SELECT column1, column2
  FROM SomeTable
 WHERE DATEDIFF('D', some_date_column, NOW) > 90;

Note due to the nature of Access Database Engine, NOW will return the current timestamp of the client machine rather than that of the machine on which the database file resides i.e. the user can change their local machines' clock to affect the functionality of your SQL code.