Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi... any ideas to convert ( 15/04/2017 - 15/05/2017)
To get 15/05/2017 as date?.....
I tried right(field,10) as Rep_Date......
Store into qvd.....
Then load Date(Rep_Date) as Rep_Date from.......and........ didnt worked....
Even
Date(Date#(Rep_Date, 'MM/DD/YYYY' ) as Reporting Date ..... didn t worked....
Any Ideas?
Hi Marvin,
Left(Right(Date,11),10) As Date;
and then
Date(Date#(Left(Right(Date,11),10),'DD/MM/YYYY'),'DD/MM/YYYY') As Date
Thanks,
Vitalii
Perhaps like this: Date(Date#( Trim(Replace(Subfield(Rep_Date,'-',-1),')','')), 'MM/DD/YYYY' ),'MM/DD/YYYY') as Reporting Date
SET ThousandSep='.';
SET DecimalSep=',';
SET MoneyThousandSep='.';
SET MoneyDecimalSep=',';
SET MoneyFormat='#.##0,00 €;-#.##0,00 €';
SET TimeFormat='hh:mm:ss';
SET DateFormat='DD/MM/YYYY';
SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';
SET MonthNames='Jan;Feb;Mrz;Apr;Mai;Jun;Jul;Aug;Sep;Okt;Nov;Dez';
SET DayNames='Mo;Di;Mi;Do;Fr;Sa;So';
tmp1:
Load *, date(right(Field,10)) as Date;
Load * Inline [
Field
15/04/2017 - 15/05/2017
];
store tmp1 into [test.qvd] (qvd); DROP Table tmp1;
LOAD Field,
Date
FROM
[test.qvd]
(qvd);
Thank to all of you..... today I finally solved it .... don t know why it did worked with some of the ways I tried yesterday.
I did with
Table A:
Right(fieldname,10)
STORE... qvd
Drop tabla A:
Table B:
Load
Date(Date#...etc
AND IT DID WORKED
i did using
date(date#(trim(SubField(Field,'-',2)),'DD/MM/YYYY')) as newdate