how to convert number to Date Format

[#1]

i have the following number

Test)

101110.

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.

Best

Brad

[tresesco]

How do you interpret it?

first two digits for month? second two for year? last two day?

Then try like:

Load

Makdate(2000+num(mid(yourfield,3,2)) , num(left(yourfield,2)), num(right(yourfield,2)) )  as Date

[#3]

First two year

Second two Month

Sent from my iPhone

[sujeetsingh]

Coyen,

If this is not a date field .

Then you need to calculate it as

String and expressions

[er_mohit]

Try this in text object

and replace code with field

=left(Date#('101110'),2)&'-'&(Mid( Date#('101110'),3,2))&'-'&'2'&Mid( Date#('101110'),2,3)

[tresesco · Accepted solution]

Then try:

Load

Makdate(2000+ num(left(yourfield,2)), num(mid(yourfield,3,2)), num(right(yourfield,2)) )  as Date