Hi,
I have one QVD which will refresh on daily basis. based on that i have to count Projects on daily basis..
for example :
in my report i am showing data from 201611.
So from 201611 to latest month 201806 of till date i have 150 Projects
so when i report them in my report i have to show the 150 projects in june month
once i enter to july 1st again it should count from 201611 to july 31st and show number in july month.
once i enter to Aug 1st again it should count from 201611 to Aug 31st and show number in August month.
basically i need to take snapshot from 201611 to till date to publish the number to according month once month is completed.
from 201611 to june ending how many projects i have to count and show it in june month
from 201611 to july ending how many projects i have to count and show in July month.
Best Regards,
HK