Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have loaded some data from a web page.
This data contains a time (mm:ss.hs), but some of it shows as txt and some as a date.
I have tried MakeTime, by 1st seperating the Mins/Secs/ and Hundreths into new fields.
Time(Field,'mm:ss.ff') this does not work either.
Please can someone come up with a solution for me as I need to use this data in a line chart, and in its current format it does not work.
Thank you
Try this,
time(time#(TimeField,'hh:mm:ss')) as New_Time
Regards,
Kaushik Solanki
Try this,
time(time#(TimeField,'hh:mm:ss')) as New_Time
Regards,
Kaushik Solanki
Thank you Kaushik,
Worked a treat!!!