Subtract two dates

Business Central/NAV Developers Forum
1

Hello

When I subtract two dates, it gives me the answer in dd:hh:mm:ss format.

I need only the date>

How do I get date only?

2

I don’t see how subtracting one date from another could ever result in another date.

3

It should result in an integer that is the number of days between the two…

4

What is the C/AL statement you are using? And what are the variables involved?

5

Getting the format “dd:hh:mm:ss” indicates that your value is formatted when displayed or printed. Did you look at your code and/or preperty for the result?

6

Hi Barathy & Welcome to Dynamics User Group.

As Tony said, it will be the integer and equal to no. of days between two dates, for example:

MESSAGE(’%1’,010110D-TODAY);

The above code subtracts today’s date from 1st January, 2010 and gives me result as no. of days between two dates (in this case, 37).

Hope it helps

7

Hello

Thank you very much for your help.

When I use Datediff(“d”, date1, date2) , I got the two digit date like 36.

Thank you

Barathy

8

Are you sure you posted this to the right forum? There is no DateDiff function inside Navision.