CQ Expression- CALCDATE function

liizz · 2012-06-29

Hi all,

I was going through the Help guide on NAV, I wanted to know how to obtain this result:

Expr1 := '<CQ+1M-10D>'; // Current quarter + 1 month - 10 days
How does 'CQ' works?

RefDate := 052196D;
Date1 := CALCDATE(Expr1, RefDate);

The expression: CQ+1M-10D returns 07/20/96

How does it return 07/20/96?

Please help..

Thanks
Liizz

mohana_cse06 · 2012-06-29

Quarters
Q1 - Jan,Feb,Mar
Q2 - Apr,May,Jun

As your date is may (Q2), the last date of current Quarter is 06/30/96

and add one month to it - 07/30/96

and deduct 10days - 07/20/96

liizz · 2012-08-06

Thanks, mohana for this explanation. =D>

mohana_cse06 · 2012-08-07

liizz wrote:

Thanks, mohana for this explanation. =D>

Welcome :thumbsup:

CQ Expression- CALCDATE function

Comments

Categories