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?

 

[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.