Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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