topic remove date time field in Water Cooler

remove date time field

Anonymous — Tue, 30 Sep 2014 16:08:00 GMT

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 — Tue, 30 Sep 2014 16:14:33 GMT

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 — Tue, 30 Sep 2014 16:28:06 GMT

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 — Tue, 30 Sep 2014 16:36:46 GMT

Hi Carlos

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

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

Regards

Nitha