What does this script doing?

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

Could anyone can explain me what exactly this script doing. I am getting answer properly but can not getting.

Dual(Year(StaticoDate)&'-Q'&Ceil(Month(StaticoDate)/3),Year(StaticoDate)&Ceil(Month(StaticoDate)/3))

Re: What does this script doing?

ajsjoshua — Mon, 27 Feb 2017 05:53:33 GMT

Hi,

If the StaticoDate is 05-05-2000

Dual(Year(StaticoDate)&'-Q'&Ceil(Month(StaticoDate)/3),Year(StaticoDate)&Ceil(Month(StaticoDate)/3))

Dual((2000)&'-Q'&ceil(5/3),2000&Ceil(5/3))

5/3 is 1.66666

ceil(5/3) returns 2 because 2 is the integer that is greater to 1.66666

Dual((2000)&'-Q'&2,2000&2)

Dual function is nothing but stores two values like in text and as well as in number

so if u take an example of dual(month, month_no)

Month Month_No

Jan 1

Feb 2

Mar 3

then if u write exp like text(dual(month, month_no) it will give you Jan

and if u write like num(dual(month, month_no) it will give you 1

Regards,

Joshua.