Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good afternoon,
I don't know how I can convert a Date from Excel sheet in numeric format.
I received from Excell: '01/03/2014' and I want stored in a QVD as 20140301.
Thanks a lot for your help.
Hi,
Use Date(Date#(datefield,'DD/MM/YYYY'),'YYYYMMDD') as NewDate,
Regards,
PS
Change like
Num(Date#('01/03/2014','DD/MM/YYYY')) as NewDatefield,
Date(Date#(DateField,'DD/MM/YYYY'),'YYYYMMDD') as NewDate
I am sorry, I receive from Excell 01/03/2014 20:27 and the result shoud be 20140301
Hi,
Try this,
Date(Date#(datefield,'DD/MM/YYYY hh:mm'),'YYYYMMDD') as NewDate,
Regards,
PS
Date(Datefield,'YYYYMMDD'')
New Update please check now Actually your date is time stamp date..
Change like below
Date(Timestamp#(DateField,'DD/MM/YYYY hh:mm'),'YYYYMMDD') as NewDate
and
Num(Date(Timestamp#(DateField,'DD/MM/YYYY hh:mm'),'YYYYMMDD')) as NewDate
and
Date(Timestamp#('01/03/2014 20:27','DD/MM/YYYY hh:mm'),'YYYYMMDD')
Try below in script.
NUM(FLOOR(Date#('01/03/2014 20:27', 'DD/MM/YYYY hh:mm'))) as NEWDATE
or
NUM(FLOOR(Date#(YourDateField, 'DD/MM/YYYY hh:mm'))) as YourDateField
or
Date(FLOOR(Date#(YourDateField, 'DD/MM/YYYY hh:mm')),'YYYYMMDD') as YourDateField
I put:
Date(Date#([Fecha del Ticket], 'DD/MM/YY HH:MM'), 'YYYYMMDD') as NewDate
And in the QVD the field is in blank
Thanks a lot Joan and Anad