mibuso.com

Microsoft Business Solutions online community
It is currently Fri May 24, 2013 7:13 pm

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 4 posts ] 
Author Message
 Post subject: Convert Dates
PostPosted: Sat Mar 31, 2012 11:45 am 
Offline

Joined: Fri Jul 30, 2010 8:17 am
Posts: 227
Country: India (in)
Hi Professionals,

How could i get the date differences b\w the Workdate and the Purchase Header"."Posting Date, i tried:


Date1 :=WORKDATE;
Date2 :="Purchase Header"."Posting Date";
Date3 := evaluate(d,Date1-Date2);



Date1's datatype is Date.
Date2's datatype is Date.
Date3's datatype is Date.
On subtracting the value is of integer type


Top
 Profile E-mail  
 
 Post subject: Re: Convert Dates
PostPosted: Sat Mar 31, 2012 12:52 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Tue Sep 02, 2008 8:37 am
Posts: 4226
Location: New Delhi
Country: India (in)
how can be difference between two dates be a date?

can you explain with example?

01/02/12 - 01/01/11 = ??

_________________
-Mohana
http://mibuso.com/blogs/mohana
http://mohana-dynamicsnav.blogspot.in/


Top
 Profile  
 
 Post subject: Re: Convert Dates
PostPosted: Sat Mar 31, 2012 1:26 pm 
Offline

Joined: Tue Jun 30, 2009 9:05 am
Posts: 102
Location: Bangalore
Country: India (in)
Create a Integer variable as NoOFDays
Now calculate the same following way

NoOFDays := WORKDATE - Purchase Header"."Posting Date;

_________________
Jubelhttp://navisionplanet.com


Top
 Profile E-mail WWW  
 
 Post subject: Re: Convert Dates
PostPosted: Sun Apr 01, 2012 7:24 pm 
Offline
Moderator
MVP Microsoft Dynamics NAV
NAV TechDays 2013 attendee

Joined: Wed Jul 02, 2003 10:13 am
Posts: 7504
Location: Milan
Country: Italy (it)
[Topic moved from 'NAV Tips & Tricks' forum to 'NAV/Navision Classic Client' forum]

_________________
Regards,Alain Krikilion
Use the SEARCH,Luke! || No PM,please use the forum. || May the <SOLVED>-attribute be in your title! || Read Forum Rules before making a posting


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: Google [Bot] and 19 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: