Working with dates in ASP 1

[jazzz]

First thanks in advance you guys always got the right answers or send me to the place where I can find what I need and it is appreciated.

I need to subtract one day from a returned value from a database where I store a date. I don't want to change the Expiration Date in the database just the date that I display on my page. Here is the code I use to do just that. What I need is to subtract one day from expirationdate and display that date.

I don’t need the response.write or anything like that just what do I need to do to subtract one day from the line below or from rsItems(“ExpirationDate”) so I can display it in the line below.

<TD><div align='center'>" & FormatDateTime(rsItems("ExpirationDate"),2) & "</div></TD>


The field ExpirationDate is being pulled from a database and is fine. I want to display the previous day not the one in the database.

Life's a journey enjoy the ride...

jazzz

 

[guitardave78]

this should work

FormatDateTime(DateAdd("d",-1,rsItems("ExpirationDate")),2)

}...the bane of my life!

http://www.fuzzyd.co.uk

 

[jazzz]

Thank you my friend that was what I needed.

Life's a journey enjoy the ride...

jazzz