|
View previous topic :: View next topic
|
| Author |
Message |
Reginald Reed
New User
Joined: 02 Jun 2022
Posts: 1
Location: USA
|
|
|
|
Hi,
I know that I can use:
| Code: |
SORT FIELDS=COPY
OUTREC OVERLAY=(19:DATE1,19:19,8,Y4W) |
Which Results in:
But how can I just get back the prior month only which would
just be 05 ?
Thanks for your help. |
|
| Back to top |
|
 |
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010
Posts: 3053
Location: NYC,USA
|
|
|
|
Welcome !
You can search this forum or Google it for similar post , I am sure you will get and try some results.
Btw , what if you are in January month , ideally it should change year too to previous year , is that right ? |
|
| Back to top |
|
|
mistah kurtz
Active User
Joined: 28 Jan 2012
Posts: 316
Location: Room: TREE(3). Hilbert's Hotel
|
|
|
|
Not tested. But see if this works:
| Code: |
SORT FIELDS=COPY
OUTREC OVERLAY=(19:DATE1,19:19,8,Y4W,SUBMONS,+1,TOGREG=Y4W) |
|
|
| Back to top |
|
|
Joerg.Findeisen
Senior Member
Joined: 15 Aug 2015
Posts: 1255
Location: Bamberg, Germany
|
|
|
|
| Code: |
OPTION COPY
OUTREC OVERLAY=(19:DATE1,19:19,8,Y4T,SUBMONS,+1,TOGREG=Y4T) |
would be correct |
|
| Back to top |
|
|
|
|
