Since i noted your reply was with inline load i figure it must be right. The load from the JSON API was the issue as i was adding the script to the ORANGE Text (qlik script) and not the SQL loaded data. I could not figure that out but, when i add your conversion to the dimension it worked perfectly so happy this is working.
Thank you again Brun for your valuable time and expertise in helping the needy 🙂
I think the load was the issue as the same conversion of date proposed by Brun worked in Dimension but not in Script. Just wanted to say i really appreciate your input and thank you so much for taking the time to assist.
