Is there a way if someone enters a date, like 02/02/04, and have that date subtract from 02/04/04; so the number 2 is returned, and if you wanted to see if 02/05/04 is greater than 02/04/04 returns true?

DateDiff()

--
Curt Christianson
Owner/Lead Developer, DF-Software
www.Darkfalz.com


"joeandtel" <joeandtelus@yahoo.com> wrote in message
news:7E291B66-DE98-4247-A54C-F715516DC347@microsoft.com...[color=blue]
> Is there a way if someone enters a date, like 02/02/04, and have that date[/color]
subtract from 02/04/04; so the number 2 is returned, and if you wanted to
see if 02/05/04 is greater than 02/04/04 returns true?

> Is there a way if someone enters a date, like 02/02/04

First of all, how are you or your software going to determine if that is Feb
2 / 2004 or Feb 4 / 2002?
[color=blue]
> subtract from 02/04/04[/color]

Next, how are you or your software going to determine if that is Feb 4 /
2004 or Apr 2 / 2004 or Apr 4 / 2002?

Don't allow free text date entry! You are guaranteed to have confused
people and incorrect results.

--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/