two different Date formats to make single calender form

[#1]

I have 2 different excel files as my source file with 2 different type of Date format

LOAD

[RG Date],

Excel 1.

the date format is : 30.12.2009 (RG Date)

I changed this date with the below script to create my calender

day([RG Date]) as day,

month([RG Date]) as Month,

year

([RG Date]) as year,

week([RG Date]) as Week

RESIDENT

Pros;

Excel 2.

the date format is: 2009 januar (Month)

Now i need to integarte this format with my above sheet 1 calender format.

I could separate 2009 and Januar with the below script:

left (Month, index(Month,' ')-1) as year,

right (Month, len(Month)-index(Month,' ')) as Month,

and couldnt able to integarte with above sheet 1 calender. so that i can only have one Calender.

Thanks for your help in advance.

[#2 · Accepted solution]

Hi,

have a look into the script of the attached example.

One way it could work for you (hopefully)!

Rainer

[prieper]

Think that the DATE#-function may help you, see the attached example.

HTH
Peter

[#4]

thank you very much............

your scrpit help me a lot

cheers