topic Re: Fiscal Date Shell Script in Operating System - HP-UX

Fiscal Date Shell Script

Monte Heeren — Fri, 20 Oct 2006 16:35:20 GMT

Trying to get the fiscal date from the Unix date command, but need the fiscal date in the format : 2006-07.

Have the following script:
echo "This is a date test"
yearlong=$(date +%Y)
yearshort=$(date +%y)
echo "Year short --> " $yearshort
yearshort=$(($yearshort+1))
#if [ $yearshort -lt 10 ]
#then
# echo "less than 10 " $yearshort
# yearshort =$(string "0"+$yearshort)
# exit
#fi
echo "The fiscal date is $yearlong-$yearshort"
~

The fiscal date ends up as 2006-7.
How can I get the extra zero in the fiscal date? Trying to get the fiscal year to feed a
dbaccess query thru a script.
Monte.

Re: Fiscal Date Shell Script

Jeff_Traigle — Fri, 20 Oct 2006 16:41:03 GMT

Lots of ways to do this, no doubt, but here's a quick one off the top of my head:

yearshort=$(echo $(($yearlong+1)) | cut -c 3-)

Re: Fiscal Date Shell Script

James R. Ferguson — Fri, 20 Oct 2006 17:04:51 GMT

Hi Monte:

The easy way is to use formatted printing:

# printf "The fiscal date is %d-%02d\n" $yearlong $yearshort

Regards!

...JRF...

Re: Fiscal Date Shell Script

Yang Qin_1 — Fri, 20 Oct 2006 18:02:13 GMT

echo "This is a date test"
yearlong=$(date +%Y)
yearshort=$(date +%y)
echo "Year short --> " $yearshort
yearshort=$(($yearshort+1))
if [ $yearshort -lt 10 ]
then
echo "The fiscal date is $yearlong-0$yearshort"
else
echo "The fiscal date is $yearlong-$yearshort"
fi
exit

Yang

Re: Fiscal Date Shell Script

Bill Hassell — Fri, 20 Oct 2006 20:22:26 GMT

Leading zeros are much simpler to implement using typeset:

typeset -Z2 yearshort
yearshort=$(date +%y)
echo $yearshort

typeset has a *lot* of formatting features for variables (UPPERCASE, lowercase, leading zeros, leading spaces, trailing spaces, etc)

Re: Fiscal Date Shell Script

john korterman — Sat, 21 Oct 2006 12:44:16 GMT

Hi Monte,

based on Mr. Hassel's suggestion:

$ eval typeset -Z2 X=$(($(date +%y ) + 1)); date +%Y-${X}

regards,
John K.

Re: Fiscal Date Shell Script

Monte Heeren — Tue, 24 Oct 2006 16:43:10 GMT

Thank you to all that responded to this thread. The easyest way to solve this was to use Jeff Traigle's example.

Could not get the typeset example to work.

Please close this thread!

This is definitely a valueable resource center!

Monte.