Create variables through script

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi guys, I have a problem with variables.

I'm trying to create a master calendar, this is the code:

The problem is at row 13th, because when I create a variables at rows 7th and 8th, these are <NULL>.

So I tested the code at rows 3th and 4th, and the code doesn't work.

Why I can not extract min and max values from the table?

Let me give you an example.

Thanks for the help

Re: Create variables through script

MK_QSL — Tue, 24 Jan 2017 09:08:25 GMT

Just change the variable as below in main tab

SET DateFormat='DD/MM/YY';

MK_QSL — Tue, 24 Jan 2017 09:09:42 GMT

or use as below...

Temp:

Load

Min(Date(Date#(OrderDate,'DD/MM/YY'))) as minDate,

Max(Date(Date#(OrderDate,'DD/MM/YY'))) as maxDate

Resident Orders;

Anonymous — Tue, 24 Jan 2017 09:14:51 GMT

Maybe the OrderDate not being read as a date so use the date and date# functions on your Orders table that loads prior to the code above.

Date(Date#(OrderDate,'DD/MM/YYYY'),'DD/MM/YYYY') as OrderDate