I'm still a bit confused as to how to get my dates formatted within my
CFGRID.
Is it possible to use dateformat() within the SQL? I've tried but keep
getting syntax errors.
If not, then in the example below where does my fieldname fit into the
statement? In place of GETDATE()?
SELECT CONVERT(varchar, Day(GETDATE()))
+ '/' + CONVERT(varchar, MONTH(GETDATE()))
+ '/' + CONVERT(varchar, YEAR(GETDATE())) AS MyDate
Thanks,
Greg Griffin
Ninpro Data, Inc.
Phone: 503-598-9821
Toll Free: 800-247-6641
Fax: 503-603-1801
E-mail: [EMAIL PROTECTED]
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
