Format Date in ASP

1. If date is required in format 23-Apr-2008 then, use

day(mydate) & "-" & left(monthname(month(mydate)),3) & "-" & year(mydate)

 

 

2. If date is required in format 23/4/2008 then, use

day(now) & "/" & month(now) & "/" & year(now)