topic Re: Tomorrow's Date in QlikView

Tomorrow's Date

kevbrown — Tue, 27 Jan 2015 16:37:00 GMT

I have a table of appointments and I only want to see the appointments for tomorrow's date. The field name is "AppointmentDate" but I think it's coming down as text in my document.

Any ideas?

Re: Tomorrow's Date

Tue, 27 Jan 2015 16:57:37 GMT

Hi Kevin,

you probably want to covert to a real date then using the Date#() function.

Can then use other functions to limit to just tomorrow Today()+1 for example

hope that helps

Joe

Re: Tomorrow's Date

vinafidalgo — Tue, 27 Jan 2015 16:58:10 GMT

Can you post a QVW for example?

Have you tried to create a variable using the expression Date(Today())+1 ?

Re: Tomorrow's Date

agomes1971 — Tue, 27 Jan 2015 17:46:29 GMT

HI,

Try this,

For tomorrow =Date(Today() + 1)

HTH

André Gomes

Re: Tomorrow's Date

robert_mika — Tue, 27 Jan 2015 19:52:50 GMT

Create a button

Properties-->Action-->Select in Field

For Field

"AppointmentDate"

For search In String

=date(today()+1)

=Date(today()+1,'MM-DD-YYYY')

*the format must be exactly as the one that is your data set.

You can as well change the Dates at the Load point

in Edit Script window using Date# function.

Re: Tomorrow's Date

kevbrown — Wed, 28 Jan 2015 09:39:50 GMT

Sorted it myself just before the replies came through but thank you for the replies. Was as easy as Today()+1

Re: Tomorrow's Date

Anonymous — Wed, 28 Jan 2015 09:42:49 GMT

Date(Today(),'DD/MM/YYYY') + 1 as Tommorrow