minus one date from another

[joeandtel]

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?

[Curt_C [MVP]]

DateDiff()

--
Curt Christianson
Owner/Lead Developer, DF-Software
www.Darkfalz.com
"joeandtel" <jo*********@yahoo.com> wrote in message
news:7E**********************************@microsof t.com...

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?

[Aaron Bertrand - MVP]

> 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?

subtract from 02/04/04

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/