Re^2: Reading Date Formatted Excel Cell

That worked and gave 'Thu, Mar 01 07' which is correct
I should also have said that I wanted it in the form
dd/mm/yy that is 01/03/07
Therefore I changed this to >Date("dd/mm/yy")
This nearly worked since it gave 01/mm/07
What should mm be replaced by?

Comment on Re^2: Reading Date Formatted Excel Cell

Replies are listed 'Best First'.
Re^3: Reading Date Formatted Excel Cell by Joost (Canon) on Mar 05, 2007 at 20:13 UTC
I'm not sure, since I can't test it, but my guess would be "MM" instead of "mm". It should be in the docs (linked in my post above) "What should it profit a man, if he should win a flame war, yet lose his cool?"	[reply]
Re^4: Reading Date Formatted Excel Cell by merrymonk (Hermit) on Mar 05, 2007 at 20:29 UTC
The 'docs' say MM. I will try tomorrow Many thanks!	[reply]
Re^4: Reading Date Formatted Excel Cell by merrymonk (Hermit) on Mar 07, 2007 at 08:30 UTC
MM worked as suggested Many thanks	[reply]