how to use subfield()

[thabo2g5]

i have date data that is combined with time so i just need help to separate the data into two different columns , i'm still new in qlikview

[shraddha_g]

Can you provide sample data with expected output.?

[Anonymous]

do you  mean   , you would like to separate  Date and time    for a cilumn like 10/26/2016 12:01 PM ?

[thabo2g5]

these  10/26/2016 12:01 PM are int the same  column  i want to  separate them  so that  the date  has its own table so as time

[Anonymous]

if  0/26/2016 12:01 PM is in  "Datefield"

Date#(SubField(Datefield, ' ', 1),'MM/DD/YYYY') as  Date............

time#(SubField(Dateield, ' ', -1),'HH:MM:SS')  as Time ........  

[maxgro]

you can use the floor (for date) and the frac (for time) functions

load

  *,

  Date(Floor(Timestamp#(datetime, 'MM/DD/YYYY hh:mm tt'))) as date,

  Time(Frac(Timestamp#(datetime, 'MM/DD/YYYY hh:mm tt'))) as time

inline [

datetime

10/26/2016 12:01 PM

];