I have a column call logon time, the data format is as below.
Logon Time |
24/07/2015 01:12 |
24/07/2015 01:17 |
24/07/2015 01:17 |
24/07/2015 01:26 |
24/07/2015 01:26 |
24/07/2015 01:35 |
Thus, I set the load description below in data load editor.
SET TimestampFormat='DD/MM/YYYY hh:mm';
Then, it generates the year/month by the auto calendar script.
However, no data is available when I try to drop a selection box. I think no data can be transform.
Please help.
Desmond