PROBLEM IMPORTING DATA SYMBOLS

[inigoelv]

Hello:

I have a problem importing data from a program.

When I import the data the result is:

23/03/2008

24/03/2008

26/03/2008

29/03/2008

30/03/2008

31/03/2008

I can not modify in the origin the dates,

When I filter in excell the data appears as:

□26/03/2008

How can solve this problem and eliminate the symbol?

Thanks in advance

[#2]

Try with this in the load script:

Load:

date(Date,'DD/MM/YYYY') as DateNew

Hi

Mc

[ariel_klien]

Hi,

Try to use Date(Trim(FiledName),'DD/MM/YYYY') in the script.

BR

Ariel

[inigoelv]

Sorry, the result is the same.

[inigoelv]

Sorry, the result is the same.

[#6]

try this:

Date(PurgeChar(FieldName,'□'),'DD/MM/YYYY')

MC

[inigoelv]

Sorry, the result is the same.

I attached the data in excell to check by yourself.

[inigoelv]

Hi again:

I attach the file for understanding better the problem.

Best regards,

[shree909]

Hi ,

As far as i understand the date

26/03/2008 is differnet from the other dates

3/29/2008

3/30/2008

3/31/2008

4/1/2008

4/2/2008

4/3/2008

4/4/2008

4/5/2008

4/6/2008

4/7/2008

4/8/2008

4/9/2008

4/10/2008

so either u need to have all the dates in the same format or try to convert eveything into one format,

if ur getting differnt date formats in one date filed u can use alt function

Date(alt(date#( dat , 'MM/DD/YYYY' ),

date#( dat , 'DD/MM/YY' ),'MM/DD/YYYY') as Date in script.

Thanks

[#10]

Try this:

if(len(trim(Date))>10, date(if(SubField(Date,'/',1)=2,SubField(Date,'/',1),right(SubField(Date,'/',1),2))&'/'&SubField(Date,'/',2)&'/'&SubField(Date,'/',3),'DD/MM/YYYY'),Date)as Date

MC