_ExcelNumberFormat "YYYY-MM-DD"

[tobject 0]

I'm getting back "20100804000000" instead of "2010-08-04"

anyonee knows why?

$oSheet = $oExcel.Worksheets.Item(1);

$ReportMaxRows = $oSheet.UsedRange.Rows.Count;

_ExcelNumberFormat($oExcel, "YYYY-MM-DD",1, 3, $ReportMaxRows,3);

for $iNdx= 1 to $ReportMaxRows

$Company=$oExcel.Activesheet.Cells($iNdx, 1).Value;

$Time=$oExcel.Activesheet.Cells($iNdx, 2).Value;

$Date =$oExcel.Activesheet.Cells($iNdx, 3).Value;

MsgBox(0,"sdsdsd",$Date );

[PsaltyDS 30]

That's the way Excel stores date/time. Use .Text instead of .Value to get the text representing that value.

[beantang 0]

I think I met the same problem.But After I changed the format to the String, I got another string rather than 20100804000000.When I write it to a Excel cell, it has not turned back.Why?

How can I get "2010-08-04"?

[JoHanatCent 11]

I think I met the same problem.But After I changed the format to the String, I got another string rather than 20100804000000.When I write it to a Excel cell, it has not turned back.Why?

How can I get "2010-08-04"?

beantang - Welcome to this forum.

This is an old post and you'd be better off starting a new post with your own example script.

The solution that PsaltyDS gave is working.

Else you can use this to just convert it:

$Date = "20100804000000"
$Date = StringLeft($Date, 4) & "-" & StringMid($Date, 5, 2) & "-" & StringMid($Date, 7, 2)
MsgBox(0, '', $Date, 2)

Edited May 22, 2011 by JoHanatCent

[beantang 0]

Thanks.I'd like to do that.

But before I start a new post, can you tell me why could I get the special string?