Subtracting Two months from date

jwatson12 · #1 (**permalink**) 09-05-2002

Hello:

I am running a script that creates a database and renames the output file to append the current date in month-year format. However, I need to append the date with todays date minus two months. For example:

Aug2002 should read Jun2002.

Here is a copy of my current script:

Code:

---------------------------------------------------------------------------------
  #!/bin/sh


#Build cube
rsserver -c -m/global/site/vendor/cognos/Dealerops/models/historymodels/oduchistorydomclosmo.mdl -DLogFileName=/global/site/vendor/cognos/Dealerops/log/histcur.log -kODUCDB2U=cognos/songoc01

#Set Date Variable for appending date to file name (month-year format)
cogdate="`date +%h%Y`"
#Set Return Status variable
ret_stat=$?

#Check the return status of rsserver, if okay, do the necessary file transfers
# and update the cube on PPES and make mail subject "SUCCESS". 
# Otherwise, change mail subject to "FAILURE"
if test $ret_stat -eq 0 
then
subject="HistoryCubeBuild:SUCCESS"

cd /global/site/vendor/Dealerops/cubes
cp ODUCHISTDOMCUR.mdc /global/site/vendor/Dealerops/cubes/History/HISTCUR"$cogdate".mdc

else
subject="HistoryCubeBuild:FAILURE"
fi


MailToNames="XXXX.com" 
OutputFile=/global/site/vendor/Dealerops/log/histcur.log
cat $OutputFile | mailx -s $subject $MailToNames

exit $ret_stat

added code tags for readability --oombera

auswipe · #2 (**permalink**) 09-05-2002

Quote:

Originally posted by jwatson12
Hello:
I am running a script that creates a database and renames the output file to append the current date in month-year format. However, I need to append the date with todays date minus two months. For example:

Check with man for your version of date and see if it supports the -v switch.

Under FreeBSD, I was able to use

Code:

date -v -2m +%h%Y

Example:

Code:

FreeBSD:auswipe:/home/auswipe $ date
Thu Sep  5 13:37:22 CDT 2002
FreeBSD:auswipe:/home/auswipe $ date -v -2m
Fri Jul  5 13:37:28 CDT 2002
FreeBSD:auswipe:/home/auswipe $ date -v -2m +%h%Y
Jul2002

LivinFree · #3 (**permalink**) 09-05-2002

If you're using GNU date you can do this:

Code:

[...]
date --date="2 months ago" +%m%Y
[...]

If you're not using GNU date and would like to, you can get it at gnu.org, in the "sh-utils" package.

jwatson12 · #4 (**permalink**) 09-13-2002

Tool is not available. I am working in a production environment and cannot add utilities.

What this script is doing is calling an OLAP database kernel that generates financial numbers for a financial closing of two months prior to the system date. The filename must be in sync with the record dates in the database source.

Therefore, If System Month = Jan, then New Month = Nov, etc. Perhaps it is best to converrt the month to number. Any ideas or scripts someone can share?

Thanks,
Newbie

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
adding or subtracting days in the o/p of date	St.Fartatric	UNIX for Dummies Questions & Answers	1	05-19-2008 07:10 AM
Cron to run first day of month to calculate date 3 months ago	new2ss	Shell Programming and Scripting	1	05-17-2007 02:28 AM
Subtract 2 months from the date	mahekr2000	UNIX for Advanced & Expert Users	5	07-23-2006 12:01 PM
Subtracting date / timestamps	roadcyclist	Shell Programming and Scripting	0	06-21-2006 02:51 PM
subtracting a days from current date	rameshspal	Shell Programming and Scripting	1	03-10-2006 01:18 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by