remove date time field

[Anonymous]

Good Morning friends.

I have a qvd file.

This field is as :

06/11/2013 08:10:28 p.m. -------->  06/11/2013

Remove date time field.

I generate the sentence "FLOOR"

DATE(FLOOR(ProductosDim),'DD-MMM-YY') AS KEY2,

¿that's right?

Date:06/11/2013

Hour:08:10:28 p.m

Please!!

thanks for the support!!

[JonnyPoole]

You may need timestamp() in there to ensure its first read as a datetime ... and then floor() and then date() as follows:

Date(Floor(Timestamp(ProductosDim)) , 'DD-MMM-YY') as KEY2

[maxgro · Accepted solution]

if you have a field with  "p.m."

first text box

=timestamp#(replace('06/11/2013 08:10:28 p.m.', '.', ''), 'DD/MM/YYYY hh:mm:ss tt')

second

=date(floor(timestamp(timestamp#(replace('06/11/2013 08:10:28 p.m.', '.', ''), 'DD/MM/YYYY hh:mm:ss tt'))))

third

=time(frac(timestamp(timestamp#(replace('06/11/2013 08:10:28 p.m.', '.', ''), 'DD/MM/YYYY hh:mm:ss tt'))))

replace 06/11/2013..... with your field

[Anonymous]

Hi Carlos

DATE(FLOOR(ProductosDim),'DD/MM/YY')  as Date

DATE(FLOOR(ProductosDim),'hh:mm:ss tt')  as Time

Regards

Nitha