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!!
Something like this might help u..
1. date(floor(timestamp#(ProductosDim,'M/D/YYYY h:mm:ss[.fff] TT')),'DD-MMM-YY') as date
2. time(frac (timestamp#(ProductosDim,'M/D/YYYY h:mm:ss[.fff] TT'))) as time
in your timestamp under time 08:10:28 p.m is a wrong format. We need to trim the '.' from P.M
so your expression becomes
=date(floor(timestamp#(replace('06/11/2013 08:10:28 p.m','.',''),'MM/DD/YYYY hh:mm:ss TT')),'DD-MMM-YY')
Something like this might help u..
1. date(floor(timestamp#(ProductosDim,'M/D/YYYY h:mm:ss[.fff] TT')),'DD-MMM-YY') as date
2. time(frac (timestamp#(ProductosDim,'M/D/YYYY h:mm:ss[.fff] TT'))) as time
in your timestamp under time 08:10:28 p.m is a wrong format. We need to trim the '.' from P.M
so your expression becomes
=date(floor(timestamp#(replace('06/11/2013 08:10:28 p.m','.',''),'MM/DD/YYYY hh:mm:ss TT')),'DD-MMM-YY')
Duplicate post
Hi,
Try something like below
=Date( Makedate(mid(value,7,4),Mid(value,4,2),mid(value,1,2) ) , 'DD/MM/YYYY')
hope it helps
Kiru