Tomorrow's date

[HomeDawwg]

Im hoping there is an easy solution to this, i cant see a way to do it.

I basically just want the date of tomorrow (Similar to the TODAY function, but a day in advance).

Any ideas?

Ta,

Darren

 

[jongpau]

Yes, that is easy to do; try this:

MESSAGE STRING(TODAY + 1,"99/99/9999":U) VIEW-AS ALERT-BOX.

HTH

Paul

 

[HomeDawwg]

Thanks Paul.

For some reason i thought TODAY + 1 wouldnt work...its been a long week

 

[sdjensen]

You could also use the add-interval function


ADD-INTERVAL (datetime, interval-amount, interval-unit) datetime

• An expression whose value is a DATE, DATETIME, or DATETIME-TZ.

interval-amount

• A signed integer (positive or negative) indicating the amount of time you want to add to or subtract from datetime value.

interval-unit

• A character constant, or a character expression that evaluates to one of the following time units: ‘years’, ‘months’, ‘weeks’, ‘days’, 'hours’, ‘minutes’, ‘seconds’ or ‘milliseconds’. These values are case insensitive and may be singular.