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 said:
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!