Tomorrow's Date

[kevbrown]

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?

[#2]

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

[vinafidalgo]

Can you post a QVW for example?

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

[agomes1971]

HI,

Try this,

For tomorrow     =Date(Today() + 1)

HTH

André Gomes

[robert_mika]

Create a button

Properties-->Action-->Select in Field

For Field

"AppointmentDate"

For search In String

=date(today()+1)

or

=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.

[kevbrown · Accepted solution]

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

[Anonymous]

HI

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