Re: [sqr-users] Problem with Date Format in .csv

[Amit Mundra <amitgmundra@yahoo.com>]

Vaibhav,

As Darshil mentioned, this is an Excel problem. If you open the
csv file in 
notepad.exe, it should look exactly the same as it does in html.
Excel just 
changes the formatting to what you are seeing now. In fact, if
you click on any 
date cell and look in the formula bar, it will show up as you
wanted. In order 
to change the view in Excel, select the date column, select
formatting from 
right click menu and change the formatting to how you want it.

Hope that helps.

-Amit

Darshil Mehta wrote:
> Vaibhav,
> 
> I guess it has nothing to do with your code. This is excel
limitation that 
> excel changes the date format according to excel's own
setting.
> 
> Cheers
> 
> Darshil
> 
> 
> 
> 
> 
> vaibhav_jindal@non.agilent.com
> Sent by:
sqr-users-bounces+darshil.mehta=lntinfotech.com@sqrug.org
> 08/07/2004 03:33 PM
> Please respond to "This list is for discussion about the SQR
database 
> reporting       language from Hyperion Solutions."
> 
>  
>         To:     sqr-users@sqrug.org
>         cc: 
>         Subject:        [sqr-users] Problem with Date Format
in .csv
> 
> 
> Hi 
>  
>  
> I am having some problem in the date formats.The problem is
that in the 
> main query iam converting the date in mm/dd/yy hh:mm:ss AM
format like 
> this :
> TO_CHAR(ooha.ordered_date, 'mm/dd/yy HH:MM:SS AM')
&ORDERED_DATE (15,3500)
>  
> and while creating the csv , iam giving : 
> let $brb_csv_data = $brb_csv_data || ',' || '"' ||
&ORDERED_DATE  || '"'
>  
> as a result, in the html result file .. iam getting the date
in the 
> correct format eg : 2/12/02 01:20:03 AM 
> but in the csv that is generated .. it is automatically 
converting the 
> time into 24 hour format : 
> 3/19/2003 13:03 
>  
>  
> What I want is that the date in csv format should also come
the same as in 
> the html format.
> Can someone suggest some alternative.....
>  
> 
> Thanks & Regards
> 
> Vaibhav Gupta
> Business Intelligence and Enterprise Reporting
> TCS @ Agilent Technologies
> 
>  
> 
>  
> 
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users
> 
>
______________________________________________________________________
> 
> 
> 
> 
>
______________________________________________________________________
> 
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users
> 
> 


        
                
__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
http://promotions.yahoo.com/new_mail 

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users