Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
alex-wb
Contributor III
Contributor III

Date Fields wont work with variables

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

 

alex-wb_0-1620232753619.png

 

1 Reply
JuanGerardo
Partner - Specialist
Partner - Specialist

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