Date Format Question 2

[nsukari]

I know almost nothing about Cold Fusion, so I know this will be really easy for other people. I need to format a date that is output from an access table to m/d instead of mm/dd/yy. It is already formatted as m/d in Access, but when it comes over in CF, it comes over as mm/dd/yy. Here is my CFquery field. #DateFormat(DOB)#

Please help!!!

Thanks

 

[bricenoej]

In your cold fusion page.. put this format to the database field..

<cfoutput># LSDateFormat(query.field,'MM/DD') #</cfoutput>

Greetigns...bricenoej

 

[SidianConsulting]

You would want to do this:

#DateFormat(DOB,"m/d/y")#

The second attribute of DateFormat() is a mask. You can see how to use masks for this function in other ways here (CFMX):

http://livedocs.macromedia.com/cfmxdocs/CFML_Reference/functions-pt159.jsp#1103264

-Tek

 

[nsukari]

Thank you so much. Both methods work great!