Week(now()) cause for straight table refresh?

[#1]

Hello,

I have a straight table which shows the number of hours a person had to work according tot a certain norm. To give sensible results I used Week(now()) to display the current amount of hours.

But now the straight table is constantly refreshing and takes a lot of resources (like CPU and memory). Can the use of Week(now()) be the cause?

Is there another solution to sum up the hours and show the sum for the current week?

Thanks!

[swuehl · Accepted solution]

Now() is returning the time at function call. As the help states, this may result in performance problems and that is what you see.

But you could probably use Now(0) or Now(2) to prevent performance issues, please have a look at the Help for details.

Regards,

Stefan

[#3]

Hi,

If you have data only till this week, week=max(week) in set analysis will be enough. However what is the datavolume here?

Thanks,

Kiran.

[#4]

Thanks swuehl, that did the trick.

I was looking in the help but couldn't find anything.