Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
When i set an expressionto use the today() to calc network days it works great. However when I refresh the app it will not refresh this column. The only way this column gets freshed is when I close the app and restart it. is there a way around this?
It is strange... BTW, the correct result today is 5, not 6. In any case, I recommend some changes. Most important, redefine "today" as the reload time rathter than actual current date:
NetWorkDays(MonthStart(ReloadTime()),floor(ReloadTime())-1)
Regards,
Michael
What expression you are using?
Regards,
Kaushik Solanki
NetWorkDays(MonthStart(Today()),(Today())-1)
Expression seems to be ok.
Is it possible for u to send the QVW file, with the data.
Regards,
Kaushik Solanki
How do I add the QVW file? Also, the function works great. lets say it yields "5" days for the field, the next day I can come in and try to refresh the file and it will still say "5" days', however if I close the app down and open it back up it will then say "6" days.
It appears to be a strange behavior.
You can click on "Use Advanced Editor" above the post area, to include the attachment.
Regards,
Kaushik Solanki
I am using the personal edition.
It is strange... BTW, the correct result today is 5, not 6. In any case, I recommend some changes. Most important, redefine "today" as the reload time rathter than actual current date:
NetWorkDays(MonthStart(ReloadTime()),floor(ReloadTime())-1)
Regards,
Michael
I will give this a try, thanks soooo much for your help!!