Hi,
I am scheduling a commission report based on half month period. The period is being calculated based on the date the report is automatically created. I use the Excel formula =today() for this.
For example:
On each 7th of the month a commission report is automatically scheduled. Based on the 7th of the month I calculate the date range of the 2nd half of the previous month. I automatically receive the file in my email.
When I open the file on the 8th of the month, Excel automatically recognizes todays date, so the date range is not being calculated correctly again which causes trouble for the outcome of the report.
A solution is that the date when the report is created does not change after wards, so I though of retrieving the Work Date out of Navision on the date that the report will automatically be created.
How can I get the work date out of NAV? Or are there any other solutions?
Date
Votes
2 comments
-
Jet Reports Historic Posts Official comment Hi,
So I think what you're saying is that the =TODAY() function is being recalculated when you open the report and you don't want this behavior because you want to see the date the report was run. Is that correct?
In this case, you can just wrap the TODAY function in a Jet NP(Eval) function like this:=NP("Eval","=TODAY()")
Make sure you paste this in exactly with the quotes around the TODAY function or it won't work. Then as long as you have +VALUES or +LOCK in cell A1 of the report, this should not be recalculated each time you open the file. Does that work for you?
Regards,
Hughes -
Jet Reports Historic Posts Hi Hughes,
So Simple! Thanks! It works great.
Regards,
Roy
Please sign in to leave a comment.