Date Diff

[marydn]

Hi,

I have a table with 4 date fields in it. I want the end-user to be able to enter a date and then have the program take that date and subtract it from all the other dates stored in the table. Does any one have a good suggestion on how to accomplish this? I know there has to be an easy solution, but it's just not coming to me.

Thanks,


M

 

[JohnYingling]

lngDays = DateDiff("d",dte1,dte2) ' days Diff
dte1 and 2 must be Variant Date or convertible to such.
See DateValye and DateSerial.

http://www.VBCompare.com

Compare Code (Text)

http://www.VBSortGen.com

Generate Sort in VB or VBScript