Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Help nothing works. I want to convert a date and time field to time only
The field I'm converting always looks like this with dates as 00/01/1900 with the time after ie
00/01/1900 00:01:03
00/01/1900 10:05:13
00/01/1900 15:29:22
00/01/1900 20:44:52
nothing seems to extract the time only any ideas
oik iv just tested this and works using your excel.
Load your excel,
do a resident load with the below for time
time(subfield(time,'Space' ,1)) as Time 2
and it works fine I can send you the app if this does not work
See, I tried with your attached excel and it worked.