#dateFormat(maint_report_date, 'mm/dd/yyyy')#
----- Original Message -----
From: "Robert Orlini" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, May 05, 2004 8:51 AM
Subject: RE: Syntax error on Where statement?
> Sounds good. I converted it to date/time.
>
> My dates now display as 2004-03-08. How do I make it display as 03/08/2004
in my forms?
>
> I tried
#convert(datetime,convert(char(10),search.maint_report_date,101))#, but it
does not recognize datetime.
>
> Robert O.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
