Date Fields wont work with variables

[alex-wb]

Hi all,

Below is some code I have written and I am wondering why when in the coloured part of the script I use my CLOSE_DT field instead of the CLOSE_DT_TIMESTAMP.autocalendar.Date (auto generated variable) is doesn't work. Is there anyway I can mimic these autogenerated variable in my load script, I really hate the long named variables. 

Thanks,

Alex

[JuanGerardo]

Hi @alex-wb, probably is because of the date format, if autoCalendar.Date uses a different one (for example DD/MM/YYYY) as CLOSE_DT (for example MM-DD-YY).

Anyway, you can build your own calendar table or edit the autoCalendar functions to adapt to what you want.

JG