topic Re: How compare the actual date and time with a variable create in VB macro? in QlikView

How compare the actual date and time with a variable create in VB macro?

Wed, 22 Oct 2014 18:42:24 GMT

Hi all,

How compare the actual date and time with a variable create in VB macro?

I tried this code, but the result is always "exit" independing what my test time.

Sub testa_horario()

vDateAtual = now()

vDate = date()&" 11:00:00"

if vDateAtual > vDate then

msgbox("run macro II")

else

msgbox("exit")

End if

End sub

Thanks!

Re: How compare the actual date and time with a variable create in VB macro?

stigchel — Wed, 22 Oct 2014 18:53:07 GMT

To assign variables use Set (or Let) so:

Let vDateAtual = now()

Re: How compare the actual date and time with a variable create in VB macro?

stigchel — Wed, 22 Oct 2014 18:56:16 GMT

For the difference between Let and Set see e.g.

use of SET and LET in script

Re: How compare the actual date and time with a variable create in VB macro?

Wed, 22 Oct 2014 19:12:08 GMT

Thank you, but I need create and compare the variables in a macro, no in the load script.

Re: How compare the actual date and time with a variable create in VB macro?

Anonymous — Wed, 22 Oct 2014 20:08:52 GMT

This should do it:

Sub testa_horario()

vDateAtual = Now()

vDate = cdate(date()&" 11:00:00")

if vDateAtual > vDate then

msgbox("run macro II")

else

msgbox("exit")

End if

End sub

Re: How compare the actual date and time with a variable create in VB macro?

Wed, 22 Oct 2014 20:50:19 GMT

It works! Thank you!