mibuso.com

Microsoft Business Solutions online community
It is currently Thu Aug 21, 2014 10:00 pm

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 4 posts ] 
Author Message
 Post subject: CQ Expression- CALCDATE function
PostPosted: Fri Jun 29, 2012 9:54 am 
Offline

Joined: Thu Dec 16, 2010 8:11 am
Posts: 97
Country: Bangladesh (bd)
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


Top
 Profile E-mail  
 
 Post subject: Re: CQ Expression- CALCDATE function
PostPosted: Fri Jun 29, 2012 10:12 am 
Offline
MVP Microsoft Dynamics NAV

Joined: Tue Sep 02, 2008 8:37 am
Posts: 4590
Location: Hyderabad
Country: India (in)
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

_________________
-Mohana
http://mibuso.com/blogs/mohana
http://mohana-dynamicsnav.blogspot.in/
https://www.facebook.com/MohanaDynamicsNav


Top
 Profile  
 
 Post subject: Re: CQ Expression- CALCDATE function
PostPosted: Mon Aug 06, 2012 8:58 pm 
Offline

Joined: Thu Dec 16, 2010 8:11 am
Posts: 97
Country: Bangladesh (bd)
Thanks, mohana for this explanation. =D>


Top
 Profile E-mail  
 
 Post subject: Re: CQ Expression- CALCDATE function
PostPosted: Tue Aug 07, 2012 9:09 am 
Offline
MVP Microsoft Dynamics NAV

Joined: Tue Sep 02, 2008 8:37 am
Posts: 4590
Location: Hyderabad
Country: India (in)
liizz wrote:
Thanks, mohana for this explanation. =D>

Welcome :thumbsup:

_________________
-Mohana
http://mibuso.com/blogs/mohana
http://mohana-dynamicsnav.blogspot.in/
https://www.facebook.com/MohanaDynamicsNav


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 4 posts ] 

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: No registered users and 10 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to: