Thread: how to change date format
View Single Post
  #3 (permalink)  
Old September 14th, 2005, 01:28 PM
kanu75 kanu75 is offline
Registered User
  
Join Date: Sep 2005
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default
Hi

use the format option in sql statement

sSql = " SELECT Format(dateField.date, 'dd-mm-yyyy') as dateformatted,"



result would be <%=dateformatted%> dd/mm/yyyy

kanu