Export to excel date problem 1

[QatQat]

Hi there,

sorry to post continuosly but coming from ASP my PHP is not up to scratch yet.

I have succesfully managed to export to excel the output of a page.



header("Content-Type: application/vnd.ms-excel; name='excel'");
header("Content-disposition: attachment; filename=" .date("Y-m-d").".xls");

include 'ReportTableHeading.Include';


the code above works perfectly but, when it comes to a datetime field it only outputs the time (00:00:00).

Changing the excel column setting to date at a later stage will show the correct date value.

Can I control excel's output to each single column?
If not, how do I avoid this and output only date with no time?

Thanks

Qatqat

Life is what happens when you are making other plans.

 

[sleipnir214]

datetime field"?


Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[QatQat]

Yep,

SQL server.

Qatqat

Life is what happens when you are making other plans.

 

[sleipnir214]

I don't understand what it is you're trying to do.


Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[pisaac]

This works - header("Content-Type: application/vnd.ms-excel; name='excel'");
header("Content-disposition: attachment; filename=" .date("Y-m-d").".xls");

Some thing to do with using (") inside (') or vice versa...

 

[pisaac]

Sorry this is the one that works...

header("Content-disposition: attachment; filename=" .date('Y-m-d').".xls");

 

[Bastien]

When you do your select, why not use the

Date_format("format", date_field)

to get the correct date on the field?

Bastien

Cat, the other other white meat

 

[QatQat]

Thank you Bastien,

although date_format does not work with MSSQL you gave me a good tip


select datepart and join YYYY/MM/DD into a variable


Thanks


Qatqat

Life is what happens when you are making other plans.