ODBiC Discussion Board


RE: UPDATEFORM: how to use formatting when displaying the values of fields, Ilona Morison, 07-09-2002

use format in query

by Louis van Eijk
July 11, 2002 01:39

Use SQL queries to format the date the way you want:

format(datefield,'dd-mm-yyyy hh:mm') AS datefield

or you can even use

format(datefield,'dd-mmmm-yyyy hh:mm') as datefield

good luck.

Louis



Replies:


Post Your Reply:

Name   
E-mail  optional
Topic  
Message:

HTTP Link: 
Link text: 


Copyright ©1997, Roger Harris. All rights reserved.