Dates

[#1]

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.

[PrashantSangle]

Hi,

Use Date(Date#(datefield,'DD/MM/YYYY'),'YYYYMMDD') as NewDate,

Regards,

PS

[its_anandrjs]

Change like 

Num(Date#('01/03/2014','DD/MM/YYYY')) as NewDatefield,

Date(Date#(DateField,'DD/MM/YYYY'),'YYYYMMDD') as NewDate

[#4]

I am sorry, I receive from Excell    01/03/2014 20:27 and the result shoud be 20140301

[PrashantSangle]

Hi,

Try this,

Date(Date#(datefield,'DD/MM/YYYY hh:mm'),'YYYYMMDD') as NewDate,

Regards,

PS

[yduval75]

Date(Datefield,'YYYYMMDD'')

[its_anandrjs]

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')

[MK_QSL]

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

[#9]

I put:

Date(Date#([Fecha del Ticket], 'DD/MM/YY HH:MM'), 'YYYYMMDD') as NewDate

And in the QVD the field is in blank

[#10]

Thanks a lot Joan and Anad