topic Run macro only on Monday. in QlikView

Run macro only on Monday.

Anonymous — Wed, 28 Mar 2012 13:32:16 GMT

I have an application that updates every day.
I need to run a macro after this update only on Monday.

Does anyone have an idea how to do this?

CELAMBARASAN — Wed, 28 Mar 2012 14:01:43 GMT

Hi,

You can restrict it inside the macro itself

if(DatePart("w",Date(),1) <> 2) then

exit sub

end if

Which should be at the start of the sub routine

Celambarasan