How do I convert a 7 digit date?

[akile002]

I have a date field that is 7 digits long. The first 3 numbers are the year, the next two are the month, and the last 2 are the day. For example, I have 1040513 which I want to convert to 05/13/2004. Does anyone know what kind of format the first number is in? If the year is less than 2000, the number will be formatted as YYMMDD and I can work with that, but I haven't found a way to conver the years from 2000 and later.

[swuehl]

Well, it's almost impossible to exactely know the format of your date with the information given, I think it's better to ask someone who actually knows the definition (or read the appropriate reference manual).

Could be something similar as described by Billy Brennan here:

http://community.qlik.com/message/353919#353919

If it's something like this, you can do it like

Date( Date#(DateField + 19000000,'YYYYMMDD'), 'MM/DD/YYYY')