in reply to Re: Reading Date Formatted Excel Cell
in thread 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
      The 'docs' say MM.
      I will try tomorrow
      Many thanks!
      MM worked as suggested
      Many thanks