Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
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
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
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
Hi Carlos
DATE(FLOOR(ProductosDim),'DD/MM/YY') as Date
DATE(FLOOR(ProductosDim),'hh:mm:ss tt') as Time
Regards
Nitha