use #DateFormat(date_added,"mm.dd.yyyy")#
Sincerely,
Shane Witbeck
Webmaster
[EMAIL PROTECTED]
www.digitalsanctum.com
-----Original Message-----
From: Anand Sunny [mailto:[EMAIL PROTECTED]]
Sent: Sunday, June 04, 2000 1:23 PM
To: [EMAIL PROTECTED]
Subject: #DateFormat(abcd)#
#DateFormat(abcd)# using Access (2000)worked just fine on my pws/98. While
uploaded it onto the iis/nt using Access (??) is giving problem. The problem
is the #Date# which is a Date/Time field in the db is outputting "6/4/200"
instead of "6/4/2000". I checked it with #DateFormat(Now())# where year
shows '2000'.
Can anyone help me in this regard please? I appreciate it very much. Thanks
in advance.
APS
----------------------------------------------------------------------------
--
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.
------------------------------------------------------------------------------
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.