Can anyone figure out why this isn't working?

[#1]

Hi all,

I have the attached script which I'm using to try and create a temporary calendar table that simply holds dates from my vMinDate to my vMaxDate. For some reason the table isn't loading properly and the only result I get is one entry stating '30/12/1899'!

Can anyone see anything glaringly obvious from the code that I'm missing as I can't seem to figure this one out?!

Any help is appreciated,

Thanks,

Samuel

[alexandros17]

Dates format is unrecognized, try with

'2020/12/31' and '2015/01/01'

[#3]

Unfortunately this isn't correcting the issue, I'm rather stumped by this!

[Anonymous]

what is your dateformat? can you create a texstobject with (date(today()).

Use this Format for your calendar

[Ralf-Narfeldt]

You  have some data format variables at the beginning of the script, does it say this or something else?

SET DateFormat='MM/DD/YYYY';

[tresesco · Accepted solution]

Redefine your variables like:

let vMaxDate= Num(MakeDate(2020, 12, 31));

let vMinDate= Num(MakeDate(2015, 1, 1));

To explain why that is not working:

'31/12/2020' - is actually being expanded (because of $) and generating a number

31 divided by 12 divided by 2020 ->0.0012...       //      '/' is being considered as numeric operator

And if you apply date(0.0012)- you get the first that of qv calendar system : '30/12/1899'

[simenkg]

the variables needs to be numbers, not strings.

let vMaxDate = Floor(Date#('31/12/2020','DD/MM/YYYY'))

let vMinDate = Floor(Date#('01/01/2015','DD/MM/YYYY'));

or just use

let vMaxDate = Floor(MakeDate(2020,12,31));

let vMinDate = Floor(MakeDate(2015,01,01));

[sunny_talwar]

Try this may be:

LET vMaxDate = Date#('31/12/2020', 'DD/MM/YYYY')

LET vMINDate = Date#('01/01/2015', 'DD/MM/YYYY')

[#9]

Just like to take the opportunity to thank everyone who's contributed, I can only mark a few questions though so please don't get offended if it isn't yours.