Get the right Date format

[nordav]

I am trying to retreive a date as a string in matlab, the SQL...
"SELECT FORMAT(execution_time +10, ''YYYYWW'') from my_table"

...gives me "20071", and I want it to be 200701 to avoid duplicate questions when I make comparison.

How do I force Access not to drop the zero?

[russellb]

SELECT DatePart("yyyy", execution_time +10)*100 +DatePart("ww", execution_time +10)
from myTable

[nordav]

Thanks! Works great!

But it gave me a new problem
How do I specify Access to use ISO standard "week of year" numbering?

(2005-01-01 (YYYY-MM-DD) is a saturday)

DatePart(''W'',DateValue(''2005-01-01'')) gives "1" but it should be "53" according to ISO 8601