Re: DateDiff Question (James Blaha)

2003-06-06 Thread James Blaha
Jochem, Thanks again! All your points were well made. Regards, JB Jochem van Dieten wrote: >James Blaha wrote: > > >>Thanks a million! Does the date format have to be in the -mm-dd format? >> >> > >It doesn't have to be. But you wrote "6/3/03", and I wouldn't know what >date that is

Re: DateDiff Question (James Blaha)

2003-06-06 Thread Jochem van Dieten
James Blaha wrote: > > Thanks a million! Does the date format have to be in the -mm-dd format? It doesn't have to be. But you wrote "6/3/03", and I wouldn't know what date that is. I presume the "03" means 2003, but how about the rest? Is that March 6 or June 3? Do you know? Does the next d

Re: DateDiff Question (James Blaha)

2003-06-06 Thread James Blaha
Jochem, Thanks a million! Does the date format have to be in the -mm-dd format? Regards, James Blaha Jochem van Dieten wrote: >James Blaha wrote: > > >>Is below the best and only way to easily find out how many days are >>between 2 dates? Im writing a template for a file backup where

Re: DateDiff Question (James Blaha)

2003-06-06 Thread Jochem van Dieten
James Blaha wrote: > > Is below the best and only way to easily find out how many days are > between 2 dates? Im writing a template for a file backup where files > that are older then 5 day will be deleted and Im not sure what the > easiest best practice approach would be for the days check.

DateDiff Question (James Blaha)

2003-06-06 Thread James Blaha
All: Is below the best and only way to easily find out how many days are between 2 dates? Im writing a template for a file backup where files that are older then 5 day will be deleted and Im not sure what the easiest best practice approach would be for the days check. #Abs("#DateDiff("d","6/