calculate 13 months ago

andrea_mussap · #1 (**permalink**) 11-16-2007

hi,
I have a big file that contains datas since 4 years ago.

I need re-create this file but just lines that are 13 months ago from today.

see what I have: ( I have a file.ksh that calls this file.scl ok !!)

======== file.scl ================
/STATISTICS=stderr
/STABLE
/NODUPLICATES
/EXECUTE " today=`date +%Y%m%d` "
/EXECUTE " 13m_ago=`expr ${today} - 10000` "
/INFILE=$PAR_SCL1
/FIELD=(CONTA_CORRENTE, POSITION=1, SIZE=13)
/FIELD=(DATA_VENCIMENTO, POSITION=50, SIZE=10)
/CONDITION=(cond1, TEST=(DATA_VENCIMENTO > ($13m_ago) )
/INCLUDE=(CONDITION=cond1)
/KEY=(NUMERO_FATURA, ASCENDING)
/OUTFILE=$PAR_SCL2
/FIELD=(CONTA_CORRENTE, POSITION=1, SIZE=13)
/FIELD=(DATA_VENCIMENTO, POSITION=50, SIZE=10)

============================================

"DATA_VENCIMENTO" is the date that have to be in the maximum equal 13 months ago.
the layout of DATA_VENCIMENTO is 20071115 , for exemple.

I've already see the topic ( Yesterdays Date/Date Arithmetic) but it didn't help me ...

My Unix is Solaris.

does somebody can help ?
thanks , Andrea.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
calculate 13 months ago	andrea_mussap	Shell Programming and Scripting	4	11-21-2007 08:14 PM
Cron to run first day of month to calculate date 3 months ago	new2ss	Shell Programming and Scripting	1	05-17-2007 03:28 AM
some months ego	big123456	Shell Programming and Scripting	8	07-27-2005 04:31 AM
Comparing two months	pankschawla	UNIX for Advanced & Expert Users	1	02-11-2004 07:32 AM
DNS Help - Been trying to do this for months	matt2kjones	IP Networking	16	09-28-2002 10:46 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 Switch to Hybrid Mode Threaded Mode	Rate This Thread:


	Powered by