Problems with formating dates and strings

[pb]

hi!

i got the problem, that date is shown in excel as number.

date in datatable 01.01.2008
date in worksheet 1012008

another problem that a string like "1234-5678". this is transformed into different (positive or negative) number values.

i've checked this in the debugger, the value is changed directly after the call of InsertDataTable();

how does the parameter transTypes works here?

[Flash]

Hello,

Please try to set transType parameters to true.

[pb]

Thanks,

that works.

[menswatches]

I need to re-format my dates to "MMM d, yyyy". The problem I have is I
have an MSSQL database that allows <NULLS>.

I'm using this code to format the dates:
<%# IIF((dsCase.FieldValue("inj_beg", Container) <>
nothing),DateTime.Parse(dsCase.FieldValue("inj_beg ",
Container)).ToString("MMM d, yyyy"), "") %>
I'VE BEEN stuck with this, plz help
thanks a lot

[Flash]

Hello,

Please try to use following code,
String.Format("{MMM d, yyyy}", DateTime.Parse(dsCase.FieldValue("inj_beg ",Container));

Best Regards.