Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from LCC352 on Dec 15 at 4:51 PM When you say you get a "difference date" are you getting an actual date? If so, you need to change the result to be an integer. That should give you a number of days. To get months, create another field with decimals and divide by 30. It won't be 100% accurate, but it will give you a close approximation.
If you were writing code, I believe there are functions you might use, but in a simple query, you won't have that ability.
Lou
| | | ---------------Original Message---------------
From: Presita
Sent: Thursday, December 11, 2014 4:54 AM
Subject: How to Calculate Monthwise Difference from Due Date in Sq02
The query is related to asset allotments. I have calculate due date of allotment. but now I want to calculate the how many months are exceeded from due date. Could anyone please help me here |
| Reply to this email to post your response. __.____._ |   _.____.__ |
