5 Replies Latest reply: Oct 4, 2013 1:02 AM by Tresesco B

# how to convert number to Date Format

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

• ###### Re: how to convert number to Date Format

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

• ###### Re: how to convert number to Date Format

First two year

Second two Month

Sent from my iPhone

• ###### Re: how to convert number to Date Format

Then try:

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

• ###### Re: how to convert number to Date Format

Coyen,

If this is not a date field .

Then you need to calculate it as

String and expressions

• ###### Re: how to convert number to Date Format

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)