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: 
nlaughton
Contributor II
Contributor II

Date Note Being Recognized

Hello, 

 

i have a script that is working well, except that the Order_Date is not being recognized or formatted correctly, any idea what i am missing ? 

 

What my script does is loop through some order data to expand out the data for every day an order is active and list associated data related to that original order .

 

here is the original data

 

AREADAYPOWERFLAGCUSTOMERORDER_DATEDAYS_SUPPLYORDER_IENORDER_NUMBERORDER_TYPESERVICE_UNIT
North 45I881/28/20183065305546641FEAST
North 41I881/28/201830654475536565FEAST
North 28I5421/12/201848774448551122FEAST
North 42I8873/10/201847466465553331FEAST
North 30I2591/23/201815666211523111FEAST
North 23I2594/5/201810644412777417FEAST
North 15I3342/7/201828121235546555FEAST
South 90I3342/17/20187122235544669FEAST
South 15I3343/16/201828131445511223FEAST
South 17I6671/17/20183611223551113FEAST
South 20I6671/25/201810622335513111FEAST
South 20I6673/20/2018106511265656FEAST

 

here is some of what i'm getting.....

 

ORDER_DATEORDER_DAYPOWER_PER_DAYTDM_AREATDM_CUSTOMER_IENTDM_ORDER_NUMBERTDM_ORDER_TYPETDM_SERVICE_UNIT
1/0/1900145North8846641FEAST
1/1/1900245North8846641FEAST
1/2/1900345North8846641FEAST
1/3/1900445North8846641FEAST
1/4/1900545North8846641FEAST
1/5/1900645North8846641FEAST
1/6/1900745North8846641FEAST
1/7/1900845North8846641FEAST
1/8/1900945North8846641FEAST
1/9/19001045North8846641FEAST
1/10/19001145North8846641FEAST
1/11/19001245North8846641FEAST
1/12/19001345North8846641FEAST
1/13/19001445North8846641FEAST
1/14/19001545North8846641FEAST
1/15/19001645North8846641FEAST
1/16/19001745North8846641FEAST
1/17/19001845North8846641FEAST
1/18/19001945North8846641FEAST
1/19/19002045North8846641FEAST
1/20/19002145North8846641FEAST
1/21/19002245North8846641FEAST
1/22/19002345North8846641FEAST
1/23/19002445North8846641FEAST
1/24/19002545North8846641FEAST
1/25/19002645North8846641FEAST
1/26/19002745North8846641FEAST
1/27/19002845North8846641FEAST
1/28/19002945North8846641FEAST
1/29/19003045North8846641FEAST

 

 

 

here is what i would expect...only change is the order date

 

ORDER_DATEORDER_DAYPOWER_PER_DAYTDM_AREATDM_CUSTOMER_IENTDM_ORDER_NUMBERTDM_ORDER_TYPETDM_SERVICE_UNIT
1/28/2018145North8846641FEAST
1/29/2018245North8846641FEAST
1/30/2018345North8846641FEAST
1/31/2018445North8846641FEAST
2/1/2018545North8846641FEAST
2/2/2018645North8846641FEAST
2/3/2018745North8846641FEAST
2/4/2018845North8846641FEAST
2/5/2018945North8846641FEAST
2/6/20181045North8846641FEAST
2/7/20181145North8846641FEAST
2/8/20181245North8846641FEAST
2/9/20181345North8846641FEAST
2/10/20181445North8846641FEAST
2/11/20181545North8846641FEAST
2/12/20181645North8846641FEAST
2/13/20181745North8846641FEAST
2/14/20181845North8846641FEAST
2/15/20181945North8846641FEAST
2/16/20182045North8846641FEAST
2/17/20182145North8846641FEAST
2/18/20182245North8846641FEAST
2/19/20182345North8846641FEAST
2/20/20182445North8846641FEAST
2/21/20182545North8846641FEAST
2/22/20182645North8846641FEAST
2/23/20182745North8846641FEAST
2/24/20182845North8846641FEAST
2/25/20182945North8846641FEAST
2/26/20183045North8846641FEAST
Labels (2)
2 Replies
nlaughton
Contributor II
Contributor II
Author

forgot, here is the sample file. 

Brett_Bleess
Former Employee
Former Employee

Have a look at the following Design Blog post, that should give you some options to try in the script to get things properly formatted:

https://community.qlik.com/t5/Qlik-Design-Blog/The-Date-Function/ba-p/1463157

The issue should be related to how the backend source is formatting things, just FYI...  

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.