Date Note Being Recognized

nlaughton — Sat, 16 Nov 2024 01:27:26 GMT

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

AREA	DAYPOWER	FLAG	CUSTOMER	ORDER_DATE	DAYS_SUPPLY	ORDER_IEN	ORDER_NUMBER	ORDER_TYPE	SERVICE_UNIT
North	45	I	88	1/28/2018	30	653055	46641	F	EAST
North	41	I	88	1/28/2018	30	65447	5536565	F	EAST
North	28	I	542	1/12/2018	4	8774448	551122	F	EAST
North	42	I	887	3/10/2018	4	7466465	553331	F	EAST
North	30	I	259	1/23/2018	15	666211	523111	F	EAST
North	23	I	259	4/5/2018	10	644412	777417	F	EAST
North	15	I	334	2/7/2018	28	12123	5546555	F	EAST
South	90	I	334	2/17/2018	7	12223	5544669	F	EAST
South	15	I	334	3/16/2018	28	13144	5511223	F	EAST
South	17	I	667	1/17/2018	3	611223	551113	F	EAST
South	20	I	667	1/25/2018	10	62233	5513111	F	EAST
South	20	I	667	3/20/2018	10	65112	65656	F	EAST

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

ORDER_DATE	ORDER_DAY	POWER_PER_DAY	TDM_AREA	TDM_CUSTOMER_IEN	TDM_ORDER_NUMBER	TDM_ORDER_TYPE	TDM_SERVICE_UNIT
1/0/1900	1	45	North	88	46641	F	EAST
1/1/1900	2	45	North	88	46641	F	EAST
1/2/1900	3	45	North	88	46641	F	EAST
1/3/1900	4	45	North	88	46641	F	EAST
1/4/1900	5	45	North	88	46641	F	EAST
1/5/1900	6	45	North	88	46641	F	EAST
1/6/1900	7	45	North	88	46641	F	EAST
1/7/1900	8	45	North	88	46641	F	EAST
1/8/1900	9	45	North	88	46641	F	EAST
1/9/1900	10	45	North	88	46641	F	EAST
1/10/1900	11	45	North	88	46641	F	EAST
1/11/1900	12	45	North	88	46641	F	EAST
1/12/1900	13	45	North	88	46641	F	EAST
1/13/1900	14	45	North	88	46641	F	EAST
1/14/1900	15	45	North	88	46641	F	EAST
1/15/1900	16	45	North	88	46641	F	EAST
1/16/1900	17	45	North	88	46641	F	EAST
1/17/1900	18	45	North	88	46641	F	EAST
1/18/1900	19	45	North	88	46641	F	EAST
1/19/1900	20	45	North	88	46641	F	EAST
1/20/1900	21	45	North	88	46641	F	EAST
1/21/1900	22	45	North	88	46641	F	EAST
1/22/1900	23	45	North	88	46641	F	EAST
1/23/1900	24	45	North	88	46641	F	EAST
1/24/1900	25	45	North	88	46641	F	EAST
1/25/1900	26	45	North	88	46641	F	EAST
1/26/1900	27	45	North	88	46641	F	EAST
1/27/1900	28	45	North	88	46641	F	EAST
1/28/1900	29	45	North	88	46641	F	EAST
1/29/1900	30	45	North	88	46641	F	EAST

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

ORDER_DATE	ORDER_DAY	POWER_PER_DAY	TDM_AREA	TDM_CUSTOMER_IEN	TDM_ORDER_NUMBER	TDM_ORDER_TYPE	TDM_SERVICE_UNIT
1/28/2018	1	45	North	88	46641	F	EAST
1/29/2018	2	45	North	88	46641	F	EAST
1/30/2018	3	45	North	88	46641	F	EAST
1/31/2018	4	45	North	88	46641	F	EAST
2/1/2018	5	45	North	88	46641	F	EAST
2/2/2018	6	45	North	88	46641	F	EAST
2/3/2018	7	45	North	88	46641	F	EAST
2/4/2018	8	45	North	88	46641	F	EAST
2/5/2018	9	45	North	88	46641	F	EAST
2/6/2018	10	45	North	88	46641	F	EAST
2/7/2018	11	45	North	88	46641	F	EAST
2/8/2018	12	45	North	88	46641	F	EAST
2/9/2018	13	45	North	88	46641	F	EAST
2/10/2018	14	45	North	88	46641	F	EAST
2/11/2018	15	45	North	88	46641	F	EAST
2/12/2018	16	45	North	88	46641	F	EAST
2/13/2018	17	45	North	88	46641	F	EAST
2/14/2018	18	45	North	88	46641	F	EAST
2/15/2018	19	45	North	88	46641	F	EAST
2/16/2018	20	45	North	88	46641	F	EAST
2/17/2018	21	45	North	88	46641	F	EAST
2/18/2018	22	45	North	88	46641	F	EAST
2/19/2018	23	45	North	88	46641	F	EAST
2/20/2018	24	45	North	88	46641	F	EAST
2/21/2018	25	45	North	88	46641	F	EAST
2/22/2018	26	45	North	88	46641	F	EAST
2/23/2018	27	45	North	88	46641	F	EAST
2/24/2018	28	45	North	88	46641	F	EAST
2/25/2018	29	45	North	88	46641	F	EAST
2/26/2018	30	45	North	88	46641	F	EAST

Re: Date Note Being Recognized

nlaughton — Tue, 21 Jan 2020 15:05:50 GMT

forgot, here is the sample file.

Re: Date Note Being Recognized

Brett_Bleess — Tue, 18 Feb 2020 19:57:24 GMT

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

topic Re: Date Note Being Recognized in QlikView

Date Note Being Recognized

Re: Date Note Being Recognized

Re: Date Note Being Recognized