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
First two year
Second two Month
Sent from my iPhone
Makdate(2000+ num(left(yourfield,2)), num(mid(yourfield,3,2)), num(right(yourfield,2)) ) as Date
If this is not a date field .
Then you need to calculate it as
String and expressions
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)
Retrieving data ...