Hi All,
If I have the date "2018" what command can I use to just give me the result "18". Apologies in advance if this is an easy one, but I am having trouble figuring it out.
Thanks,
AM
Only Want Last 2 Digits of Year
Moderators: Dorian (MJT support), JRL
-
Marcus Tettmar
- Site Admin
- Posts: 7380
- Joined: Thu Sep 19, 2002 3:00 pm
- Location: Dorset, UK
- Contact:
Re: Only Want Last 2 Digits of Year
//assume we have this
Let>theYear=2018
//then do this ...
MidStr>theYear,3,2,result
//result now contains 18.
Let>theYear=2018
//then do this ...
MidStr>theYear,3,2,result
//result now contains 18.
Marcus Tettmar
http://mjtnet.com/blog/ | http://twitter.com/marcustettmar
Did you know we are now offering affordable monthly subscriptions for Macro Scheduler Standard?
http://mjtnet.com/blog/ | http://twitter.com/marcustettmar
Did you know we are now offering affordable monthly subscriptions for Macro Scheduler Standard?
Re: Only Want Last 2 Digits of Year
This worked - thanks!
