Using subtract function with dates

[adunaway]

I want to subtract 10 days from the current date.

I execute the following commands:

Day>the_day
Sub>the_day,10

Since today is the 6th, it returns the value -4.

The help file states that Sub can be used with dates or numbers. I would think it is smart enough to recognize the number or days in the month if it can be used for dates.

Am I doing something wrong?

[Me_again]

The help file states that Sub can be used with dates or numbers.

It does work with a date:

GetDate>date1
Let>date2=date1
Sub>date2,10
MessageModal>%date1% %date2%

but when you use Day> all you are doing is storing the day number in a variable, that variable doesn't have any connection to the month to know what 10 days before the 6th would be.

There are a bunch of examples on this forum of date arithmetic.

[Marcus Tettmar]

Sub can subtract days from dates. So you can do:

Code: Select all

GetDate>the_date
Sub>the_date,10

To return today's date minus 10 days.

But you are just subtracting 10 from the current day number. Day returns the day of the month - which is just a number. So 6 - 10 is -4.