Date format issue with an excel report output from a cold fusion file using a sql query

Excel report output for date format isn't working as it did w/in html:

Will this work with an excel output? I'm getting an error when I try to use it the same way See the enter_que output below:

<cfoutput> 

#cellbeg# Queue Name #cellend# #cellbeg# Fifo Flag #cellend# #cellbeg# User ID #cellend# #cellbeg# Due Date #cellend# #cellbeg# Document ID#cellend# #cellbeg# Invoice Number #cellend# #cellbeg# Material Amount #cellend# #cellbeg# Discount Terms Percent #cellend# #cellbeg# Discount Terms Days #cellend# #cellbeg# Discount Terms Net #cellend# #cellbeg# FINCENDT #cellend# #cellbeg# Markview #cellend# #cellbeg# Work Item #cellend# #cellbeg# Date Entered Queue #cellend# 

</cfoutput> </font>
</tr>

<cfoutput query="queueData">
#begline#
#cellbeg1# &nbsp;#queueData.queue_name# #cellend# #cellbeg1# &nbsp;#fifo_flag# #cellend# #cellbeg1# &nbsp;#RETRIEVING_USER_ID# #cellend# #cellbeg1# &nbsp;#queueData.due_date# #cellend# #cellbeg1# &nbsp;#queueData.document_id#  #cellend# #cellbeg1# &nbsp;#queueData.invoice_num# #cellend# #cellbeg1# &nbsp;#queueData.material_amount# #cellend# #cellbeg1# &nbsp;#queueData.percent#  #cellend# #cellbeg1# &nbsp;#queueData.days# #cellend# #cellbeg1# &nbsp;#queueData.net# #cellend# #cellbeg1# #queueData.FINCENDT# #cellend# #cellbeg1# #queueData.markview# #cellbeg1# #queueData.workitem#  #cellbeg1# #queueData.dateFormat(enter_que,"mm/dd/yyyy")# 
#endline#
</cfoutput> 

Open in new window

QuackdeveloperAsked:
Who is Participating?
 
QuackConnect With a Mentor developerAuthor Commented:
got it working...didn't need the queData.....at the start ... was throwing it off
0
 
_agx_Commented:
What's the error?
0
 
QuackdeveloperAuthor Commented:
there's no error being thrown I just need the dates to be formatted mm/dd/yy in the excel report
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
_agx_Commented:
Oh, it sounded like it was crashing: "I'm getting an error when I try to use it the same way ".

It should work the exact same way. If you need a two digit year, try:
          #queueData.dateFormat(enter_que,"mm/dd/yy")#

instead of:
        #queueData.dateFormat(enter_que,"mm/dd/yyyy")#
0
 
_agx_Commented:
Good catch.  I was too focused on the date mask ;-)  Though that syntax would trigger an error, so next time please be sure to accurately describe the problem and include the error message.
0
 
QuackdeveloperAuthor Commented:
reached a resolution w/o assistance
0
All Courses

From novice to tech pro — start learning today.