Jun 27, 2006 #1 daNewfie Programmer Joined Oct 14, 2004 Messages 258 Location CA I have a value in a database of 06/27/2006 how can I display it like Tuesday, June 27, 2006 Craig
Jun 27, 2006 #2 LyndonOHRC Programmer Joined Sep 8, 2005 Messages 603 Location US Try this: Code: <cfset dte=Now()> <cfoutput> #DateFormat(dte,"dddd")#, #DateFormat(dte,"mmmm")# #DateFormat(dte,'dd')#, #DateFormat(dte,'yyyy')# </cfoutput> Upvote 0 Downvote
Try this: Code: <cfset dte=Now()> <cfoutput> #DateFormat(dte,"dddd")#, #DateFormat(dte,"mmmm")# #DateFormat(dte,'dd')#, #DateFormat(dte,'yyyy')# </cfoutput>
Jun 27, 2006 #3 LyndonOHRC Programmer Joined Sep 8, 2005 Messages 603 Location US Or This: Code: <cfset dte=Now()> <cfoutput> #DateFormat(dte,"dddd, mmmm dd, yyyy")# </cfoutput> Upvote 0 Downvote
Jun 27, 2006 #4 GUJUm0deL Programmer Joined Jan 16, 2001 Messages 3,676 Location US The latter one is better, ____________________________________ Just Imagine. http://www.imajinarts.com Upvote 0 Downvote
The latter one is better, ____________________________________ Just Imagine. http://www.imajinarts.com
Jun 27, 2006 #5 FALCONSEYE Programmer Joined Jul 30, 2004 Messages 1,158 Location US orrr... SELECT datename(dw,getDate())+', '+CONVERT(varchar, GETDATE(), 107) http://www.jetansolutions.com Upvote 0 Downvote
orrr... SELECT datename(dw,getDate())+', '+CONVERT(varchar, GETDATE(), 107) http://www.jetansolutions.com
Jun 27, 2006 Thread starter #6 daNewfie Programmer Joined Oct 14, 2004 Messages 258 Location CA Thanks Guys Upvote 0 Downvote