Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try with this in the load script:
Load:
date(Date,'DD/MM/YYYY') as DateNew
Hi
Mc
Hi,
Try to use Date(Trim(FiledName),'DD/MM/YYYY') in the script.
BR
Ariel
Sorry, the result is the same.
Sorry, the result is the same.
try this:
Date(PurgeChar(FieldName,'□'),'DD/MM/YYYY')
MC
Sorry, the result is the same.
I attached the data in excell to check by yourself.
Hi again:
I attach the file for understanding better the problem.
Best regards,
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
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