Exporting Dates to Excel

HCL Domino Domino Forum
1

Hi all,

I wonder if somebody can give me a hint on this one:

When I try to export a date from a document into excel, it appears in the US format (9th Feb 2012 appears as 09/04/2012 in notes, but as 04/09/2012 in excel when exported).

I have also tried to convert to notesdatetime and pull the GMTDate out as a string, but whenever I export, then it does the same.

“Except” when the date passes the 12th of the Month, then the date shows fine in excel.

I must be missing something or is this just excel 2010 being silly.

Many thanks and look fwd

2

Subject: You could try this…

While you would keep dates stored in NotesDateTime format in the database, you could format the values being passed to Excel as strings in “dd-mmm-yy” format e.g. “17-Jul-12”. That way Excel can convert it to dd/mm/yy format without being confused