Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Friends
I need to calculate number of days of previous month.
For example: If selected month is May , then it should return number of days in April, ie 30.
Below correctly gives number of days for current month. But I need previous month.
num(Monthend(max(DATE_OF_ISSUE)) -Monthstart(min([DATE_OF_ISSUE])))
Kindly help. Thanks in advance.
Regards
Chintan
I believe so...
yes
Thanks a lot all Kamal. Vineeth and Sunny , I think this will serve my purpose !!
Hi,
yeah, the data was updated but document was not reloaded with the corrected data.. Here is the updated one.. looking fine to me.. just in case if that still can help
Sure Kamal , I will check. It can be helpful as it will work dynamically.
Other expression is static as today() is used.