ECHO 00001000 ECHO This file contains many date expressions which you may find 00002000 ECHO useful to include in your STREAMX jobs or MPEX command files. 00003000 ECHO This file contains ECHO commands, with expressions between "![" 00004000 ECHO and "]". That way you can execute it as a command file 00005000 ECHO from MPEX. To use the expressions in STREAMX you can simply 00006000 ECHO replace the "!![","]" with "{" and "}" respectively. 00006100 ECHO You should copy the appropriate expression to your 00006200 ECHO own file. Good Luck. 00007000 ECHO 00008000 ECHO ***Today's Julian date*** 00009000 ECHO 00010000 ECHO ![today-datebuild(hpyear,1,1)+1] 00011000 ECHO 00012000 ECHO ***Relative to TODAY Days*** 00013000 ECHO 00014000 ECHO ![today-hpday ] ***Last Saturday*** 00015000 ECHO ![today-datedayofweek(today-1)] ***Last Sunday*** 00016000 ECHO ![today-datedayofweek(today-2)] ***Last Monday*** 00017000 ECHO ![today-datedayofweek(today-3)] ***Last Tuesday*** 00018000 ECHO ![today-datedayofweek(today-4)] ***Last Wednesday*** 00019000 ECHO ![today-datedayofweek(today-5)] ***Last Thursday*** 00020000 ECHO ![today-datedayofweek(today-6)] ***Last Friday*** 00021000 ECHO 00022000 ECHO ![today-1 ] ***Yesterday*** 00023000 ECHO ![today+1 ] ***Tomorrow*** 00024000 ECHO 00025000 ECHO ![today+7-((hpday) mod 7) ] ***Next Saturday*** 00026000 ECHO ![today+7-((hpday+6) mod 7) ] ***Next Sunday*** 00027000 ECHO ![today+7-((hpday+5) mod 7) ] ***Next Monday*** 00028000 ECHO ![today+7-((hpday+4) mod 7) ] ***Next Tuesday*** 00029000 ECHO ![today+7-((hpday+3) mod 7) ] ***Next Wednesday*** 00030000 ECHO ![today+7-((hpday+2) mod 7) ] ***Next Thursday*** 00031000 ECHO ![today+7-((hpday+1) mod 7) ] ***Next Friday*** 00032000 ECHO 00033000 ECHO ***First day of this month*** 00033100 ECHO 00033200 ECHO ![datebuild(hpyear,hpmonth,1)] 00033300 ECHO 00033400 ECHO ***Last day of last month*** 00034000 ECHO 00035000 ECHO ![datebuild(hpyear,hpmonth,1)-1] 00036000 ECHO 00037000 ECHO ***Last day of this month*** 00038000 ECHO 00039000 ECHO ![dateadd(datebuild(hpyear,hpmonth,1),0,1,-1)] 00040000 ECHO 00041000 ECHO ***Last day of next month*** 00042000 ECHO 00043000 ECHO ![dateadd(datebuild(hpyear,hpmonth,1),0,2,-1)] 00044000