Hi Peter,
What function are you using?

You don't appear to be using the correct date format. That may be why you're running into problems.

The ISO standard is not dd-mm-yy, it's yyyy-mm-dd.

From ISO 8601...
5.2.1.1 Complete representation
When the application identifies the need for an expression only of a calendar date, then the complete representation
shall be a single numeric data element comprising eight digits, where [YYYY] represents a calendar year, [MM] the
ordinal number of a calendar month within the calendar year, and [DD] the ordinal number of a day within the calendar
month.
Basic format: YYYYMMDD EXAMPLE 19850412
Extended format: YYYY-MM-DD EXAMPLE 1985-04-12

And...
day of the week is represented by one decimal digit. Monday shall be identified as day [1] of any calendar
week, and subsequent days of the same week shall be numbered in ascending sequence to Sunday (day [7]).

calendar week is represented by two decimal digits. The first calendar week of a year shall be identified as
[01] and subsequent weeks shall be numbered in ascending sequence.

So the first Monday of the year is the start of week 01. (week number)


John



"Peter" wrote in message ...
Greetings all,

Us date format: 01/10/2009 ( January 10th 2009)

1. I want it to convert to ISO 8601 standard: dd-mm-yy
2. I want the day number (Sunday Day 1)..

I am trying all kind formats..customs..regional settings...but it gives me
wrong results..so fora example...01 June 2009...returns Saturday...

Thanks!