J
jodleren
Hi all!
I work with OLE, and want to do this:
somecell.value = some date (which i have in mm.dd.yyyy format
numberformat = "yyyy" // year only
nextcell.value = previous cell
numberformat = "mmm" // month as name
I have tried this, but it does not work:
$WB->Sheets(1)->Cells($excel_index,1)->NumberFormat="mm.dd.yyyy";
$WB->Sheets(1)->Cells($excel_index,1)-
GetMyDateFormat returns the date in "mm.dd.yyyy" format.
Is there an Excel guru here?
Eventually I'd like to add a date and format it as yyyy/mm
BR
Sonnich
I work with OLE, and want to do this:
somecell.value = some date (which i have in mm.dd.yyyy format
numberformat = "yyyy" // year only
nextcell.value = previous cell
numberformat = "mmm" // month as name
I have tried this, but it does not work:
$WB->Sheets(1)->Cells($excel_index,1)->NumberFormat="mm.dd.yyyy";
$WB->Sheets(1)->Cells($excel_index,1)-
$WB->Sheets(1)->Cells($excel_index,2)->NumberFormat="mmm";Value=GetMyDateFormat(odbc_result($result,3)); $WB->Sheets(1)->Cells($excel_index,1)->NumberFormat="yyyy";
$WB->Sheets(1)->Cells($excel_index,2)->NumberFormat="mm.dd.yyyy";
$WB->Sheets(1)->Cells($excel_index,2)-
Value=GetMyDateFormat(odbc_result($result,3));
GetMyDateFormat returns the date in "mm.dd.yyyy" format.
Is there an Excel guru here?
Eventually I'd like to add a date and format it as yyyy/mm
BR
Sonnich