[cfaussie] Dates / Times

[Andrew]

Hi,

I've got an excel spreadsheet which I am parsing with cfHSSF (http://
cfhssf.riaforge.org/)

In it are a few time fields (elapsed times, like 2 mins, 50 seconds)
which are returned as something like this: 0.00208101851852

Is there an easy way to convert that to minutes and seconds in CF?  In
Java I can use POI to return it as a date, and then format it like
this:

DateFormat df = new SimpleDateFormat(m:ss.S);
System.out.println(df.format(cell.getDateCellValue()));

Does CF have a simple way of converting the float value to a date?  I
have seen an IsNumericDate function, which returns true for this
value, but I can't see a method which allows you to create a date from
a float.  Am I missing something?

I guess I could just do it in Java if all else fails, but I was hoping
to keep it all in CF if possible.

Thanks,
Andrew.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
cfaussie group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to 
cfaussie+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en
-~--~~~~--~~--~--~---

[cfaussie] Dates

[KNOTT, Brian]

How can I get SQL to order dates by financial year not calendar
year. I want to order a query from1/72005 to 30/06/2006.



Brian Knott




--- 

This e-mail is sent by Suncorp-Metway Limited ABN 66 010 831 722 or one of its related entities Suncorp.  

 

Suncorp may be contacted at Level 18, 36 Wickham Terrace, Brisbane or on 13 11 55  or at suncorp.com.au. 

 

The content of this e-mail is the view of the sender or stated author and does not necessarily reflect the view of Suncorp. The content, including attachments, is a confidential communication between Suncorp and the intended recipient. If you are not the intended recipient, any use, interference with, disclosure or copying of this e-mail, including attachments, is unauthorised and expressly prohibited. If you have received this e-mail in error please contact the sender immediately and delete the e-mail and any attachments from your system. 

 

If this e-mail constitutes a commercial message of a type that you no longer wish to receive please reply to this e-mail by typing Unsubscribe in the subject line. 

  
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups cfaussie group.  To post to this group, send email to cfaussie@googlegroups.com  To unsubscribe from this group, send email to [EMAIL PROTECTED]  For more options, visit this group at http://groups.google.com/group/cfaussie  -~--~~~~--~~--~--~---