i haf dis problem of displaying the date difference. i noe tad the datediff function is to find the difference between two dates using dis format.

datediff("d",submit,close)
submit is start date.
close is end date.

but den my format of the dates is 25-Jun-03. & the system cant find the diff using dis format. so can anyone help me by givin me solution as to how to resolve dis problem of mine wifout me changing the format of my date. which means i wan to find the diff using dis format- 25-Jun-03

thanz...

Without reformatting your dates to mm/dd/yy format, you cannot get datediff to work.

Pat Wong
http://www.napathon.net/ - Music Around The World
For collecting tips, trade and want lists, album reviews and more.

You might want to try:

DateDiff("d", CDate(submit), CDate(close))

This is assuming that submit and close are something that can
be interpreted as a date literal.