DateDifferent=DateDiff("d",Date(),rsSelect("Expiry Date"))

tis is the code to get the date differnt between date now with the date from the DB. becoz the interval is Date(d), how can i get the time different between the time? and the PM and AM too..plz help .thank you

That will give you the 'number of days' differecnce. The other interval arguments are

Setting - Description
yyyy Year
q Quarter
m Month
y Day of year
d Day
w Weekday
ww Week of year
h Hour
n Minute
s Second


Wind is your friend
Matt
www.elitemarquees.com.au

thank you.problem solved.