i have the following number
i would like to convert this to date format so that i can get the year 2011, the Month November and the day 10 and even the week from this.
i have treid Date#(date(Test) with luck.
How do you interpret it?
first two digits for month? second two for year? last two day?
Then try like:
Makdate(2000+num(mid(yourfield,3,2)) , num(left(yourfield,2)), num(right(yourfield,2)) ) as Date