Yesterday date

[Identis]

Hello,
I have 12version, is it possible to get yesterday date ?

[Dorian (MJT support)]

Sadly v12 was released 13 years ago so is out of support.

The usual way of doing this would be :

Code: Select all

GetDate>today
DateAdd>today,D,-1,yesterday

But unfortunately DateAdd was only added in v13, 12 years ago.

GetDate was in v12 though, so that would at least be a starting point.

[JRL]

This should work in version 4 onward.

Code: Select all

//Pure Macro Scheduler
Month>mm
Day>dd
Year>yyyy

Let>today=%mm%/%dd%/%yyyy%
Sub>today,1
//Variable today is now yesterday's date.
MDL>today

//Or VBScript
VBStart
VBEnd

VBEval>now-1,yesterday
MDL>yesterday
//The result is date and time
//To have only the date
Separate>yesterday,space,vNow

MDL>vNow_1

[Dorian (MJT support)]

This should work in version 4 onward.

Code: Select all

//Pure Macro Scheduler
Month>mm
Day>dd
Year>yyyy

Let>today=%mm%/%dd%/%yyyy%
Sub>today,1
//Variable today is now yesterday's date.
MDL>today

//Or VBScript
VBStart
VBEnd

VBEval>now-1,yesterday
MDL>yesterday
//The result is date and time
//To have only the date
Separate>yesterday,space,vNow

MDL>vNow_1

Thank you for that. I'm quite amazed that Sub>today,1 detected the date correctly like that.

Seeing as GetDate was also in v12, this should also work :

Code: Select all

GetDate>today
Sub>today,1

[JRL]

I don't want to change my regional date setting to test but as I recall GetDate> presents in the format specified in regional settings. For Add> and Sub> to work with a date the date has to be in month/day/year format. No other format will work. You can use 1 digit month and day as well as 2 digit year, but the date has to be month/day/year. Another caveat if you use 2 digit year is that you can get the wrong century. 72 and smaller will give you a 20xx result but 73 though 99 will provide a 19xx result. No issues at all if you use a 4 digit year.

If you are working far into the past or future you can acquire a 5 or more digit result for the year, but you can't use more than a 4 digit year for input. Nor can you acquire a result or use an input less than 1/1/0001

[Identis]

This should work in version 4 onward.

Code: Select all

//Pure Macro Scheduler
Month>mm
Day>dd
Year>yyyy

Let>today=%mm%/%dd%/%yyyy%
Sub>today,1
//Variable today is now yesterday's date.
MDL>today

//Or VBScript
VBStart
VBEnd

VBEval>now-1,yesterday
MDL>yesterday
//The result is date and time
//To have only the date
Separate>yesterday,space,vNow

MDL>vNow_1

Thank you!!!

[Dorian (MJT support)]

I don't want to change my regional date setting to test but as I recall GetDate> presents in the format specified in regional settings. For Add> and Sub> to work with a date the date has to be in month/day/year format. No other format will work.

I just had reason to try this and can confirm that the Sub method still works even if the local date format is DD/MM/YYYY. I also tested Add, and that worked too.

Code: Select all

//My local (UK) format DD/MM/YYYY
//Output : 14/04/2023
GetDate>today

//Output : 13/04/2023
Sub>today,1