Link to home
Start Free TrialLog in
Avatar of jsuttor
jsuttor

asked on

Date Formatting (I need one day prior)

Here is the way my date is displayed and its beautiful with one exception.... How do I get my date field to display one day prior's date... Like lets say the Date_Time field displays 4/1/2005.... well that is the day I imported the stats in the database not the actual date of the stats... How can I get it to display the date for one day prior to the date in the date_time field.

<%=MonthName(DatePart("m", rs7("date_time"))) & " " & Day(rs7("date_time"))%>

j
ASKER CERTIFIED SOLUTION
Avatar of amit_g
amit_g
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial