Time Conversion

[#1]

One of the fields in my data file is Day of week and time as follows. I am trying to load them as two fields, Day of week and Time.

Mon 3:22PM

Tue 11:05AM

Mon 4:11AM

I use Left(...) for DOW, Right(...) for the Time but can't get it to show as hh:mm

left(@3,3) as dow,

Date(mid(@3,5,7),'hh:mm')  as AirTime

I have tried Time# as well.

Thanks

[MarcoWedel]

Please close this thread by marking correct (and helpful if you like) answers.

Thanks

Regards

Marco