Date Fields wont work with variables

alex-wb — Wed, 05 May 2021 16:44:38 GMT

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

Re: Date Fields wont work with variables

JuanGerardo — Wed, 05 May 2021 16:53:50 GMT

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.

topic Date Fields wont work with variables in App Development

Date Fields wont work with variables

Re: Date Fields wont work with variables