Convert No. in to Date or Year

[#1]

Hi,

i have a field in which date is given in the no. format as 19790601

plz help me to find out how to get the date,month,year from this no.

[#2]

Hi,

first you have QV to tell the format: Date#(YourNoField, 'YYYYDDMM') as example.

Now you are able to build Year, ad so on:

Load *,

Year(YourDateFormat) as Year,

Day(YourDateFormat) as Day;

Load

Date(Date#(YourNoField, 'YYYYDDMM') , 'DD-MM-YYYY') as YourDateFormat,

Field2

From .......

Hope it helps.

Rainer