Data cannot load by Auto-Calendar

desmond_mf_fung — Tue, 15 May 2018 07:57:31 GMT

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: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

topic Data cannot load by Auto-Calendar in Connectivity & Data Prep

Data cannot load by Auto-Calendar