how to check if a date is greater that current date.iam using MS Access.

Question

0.00/5 (No votes)

See more:

i tried following code..
quarry is working in Access, but not working in .net...

C#

public void fillcmbptraino()
       {
           da = new OleDbDataAdapter("SELECT tid FROM train WHERE dfdate > GETDATE", mycon);
           ds = new DataSet();
           da.Fill(ds);
           dt = ds.Tables[0];
           for (int i = 0; i < dt.Rows.Count; i++)
           {
               cmbptrain.Items.Add(dt.Rows[i].ItemArray[0]);

           }
       }

values in dfdate is

VB

dfdate
11/8/2011
1/8/2011
8/18/2011
8/25/2011

and datatype is Date/Time.

plz any one help me ..
thanks in advance....

Posted 3-Aug-11 23:02pm

Ragi Gopi

Add a Solution

2 solutions

Solution 2

=DateAdd("d", -10, [PromisedDate])
Displays a date that is 10 days before the value of the PromisedDate field.

=DateAdd("m", 1, "31-Jan-03")
Displays a date that is a month after 31-Jan-03, so the expression will evaluate to 28-Feb-03.
=DateAdd("m", 1, "31-Jan-04")

Displays a date that is a month after 31-Jan-04, and since 2004 is a leap year, the expression will evaluate to 29-Feb-04.
=DateAdd("q", 3, [PromisedDate])

Displays a date that is three quarters after the value of the PromisedDate field; for example, if the value of the PromisedDate field is 18-Jun-03, the expression will evaluate to 18-Mar-04.
=DateAdd("h", 3, [ArrivalTime])

Displays a time that is three hours after the value of the ArrivalTime field.

Posted 3-Aug-11 23:18pm

Lakhan Aanjana

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Toniyo Jackson · Accepted Answer · 2011-08-03T23:05:00

Solution 1

It should be NOW().

OP: NOW() its only working for date..thatis not considering month or year

For Month & Year you have to check like below.

SELECT tid FROM train WHERE MONTH(dfdate) > MONTH(NOW())
SELECT tid FROM train WHERE YEAR(dfdate) > YEAR(NOW())

For more info check this[^].

Posted 3-Aug-11 23:05pm

Toniyo Jackson

Updated 4-Aug-11 0:40am

v4

Comments

Ragi Gopi 4-Aug-11 5:08am

sorry, not working ....

Toniyo Jackson 4-Aug-11 5:16am

Are you getting any error?

Ragi Gopi 4-Aug-11 5:18am

no...
but when i executed quarry wit GETDATE()in access it shows error..otherwise its working in access.

Toniyo Jackson 4-Aug-11 5:20am

Check the updated answer

Ragi Gopi 4-Aug-11 5:27am

Ya buddy its working ..thanks....
then wat happen to GETDATE....

Toniyo Jackson 4-Aug-11 5:34am

GETDATE() is for Sql server. For MSAccess we have to use NOW()

Ragi Gopi 4-Aug-11 6:34am

Toniyo Jackson....NOW() its only working for date..thatis not considering month or year...

Toniyo Jackson 4-Aug-11 6:39am

Check the updated answer

Ragi Gopi 4-Aug-11 5:35am

mmhhh......