Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Date derivation

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Date derivation
# 1  
Old 02-14-2013
Date derivation
Need to get saturday's date of the previous week.

Input will be the sysdate (today's date)

Output should be previous weeks's saturday format

Your help is required extremely.

I have done all the date arthimetic calculation, but not getting the desired output. Please help
Last edited by vbe; 02-14-2013 at 12:22 PM.. Reason: rm code tags... code tags are required ofr code and data! and only code and data
# 2  
Old 02-14-2013
Quote:
Originally Posted by help_scr_seeker
I have done all the date arthimetic calculation, but not getting the desired output.
Can you show us what you tried?

Also let us know what OS and SHELL you are using:
Code:
uname -a
echo $SHELL

# 3  
Old 02-14-2013
Code:
$ uname -a
AIX cissrv67 1 6 000FBC01D900

---------- Post updated at 11:25 AM ---------- Previous update was at 11:19 AM ----------

Code:
$ echo $SHELL
/usr/bin/ksh

# 4  
Old 02-14-2013
Post what you have done so far to solve this problem...
# 5  
Old 02-14-2013
Code:
use strict;
use warnings;
use DateTime;
my $d = DateTime->now;
while ( $d->day_of_week != 6 ) {
    $d->subtract( days => 1 );
        }
        print $d->ymd;

I developed this code in perl. Unfortunately, the perl modules is not installed in the client server. So unable to use that :-(

I need some help in shell scripting.
# 6  
Old 02-14-2013
Have a look at Perderabo's thread: Date Arithmetic
# 7  
Old 02-14-2013
Quote:
Originally Posted by help_scr_seeker
Code:
use strict;
use warnings;
use DateTime;
my $d = DateTime->now;
while ( $d->day_of_week != 6 ) {
    $d->subtract( days => 1 );
        }
        print $d->ymd;

I developed this code in perl. Unfortunately, the perl modules is not installed in the client server. So unable to use that :-(

I need some help in shell scripting.
I suggest you get perl installed on the client machine as date math imho is done best in perl...
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Answers to Frequently Asked Questions

Compare date in .txt with system date and remove if it's lesser than system date

I m working on shell scripting and I m stuck where in my .txt file there is column as expiry date and I need to compare that date with system date and need to remove all the rows where expiry date is less than system date and create a new .txt with update. (1 Reply)
Discussion started by: Stuti
1 Replies

2. UNIX for Beginners Questions & Answers

Compare date in .txt with system date and remove if it's lesser than system date

Can someone help me with the code wherein there is a file f1.txt with different column and 34 column have expiry date and I need to get that and compare with system date and if expiry date is <system date remove those rows and other rows should be moved to new file f2.txt . I don't want to delete... (2 Replies)
Discussion started by: Stuti
2 Replies

3. Shell Programming and Scripting

Date: invalid date trying to set Linux date in specific format

i try to set linux date & time in specific format but it keep giving me error Example : date "+%d-%m-%C%y %H:%M:%S" -d "19-01-2017 00:05:01" or date +"%d-%m-%C%y %H:%M:%S" -d "19-01-2017 00:05:01" keep giving me this error : date: invalid date ‘19-01-2017 00:05:01' Please use CODE tags... (7 Replies)
Discussion started by: umen
7 Replies

4. Programming

Derivation of values falling on date ranges

Hi Guys, I am having below tables used in oracle bal ID BALANCE BAL_DATE 1 -11.71 01-JAN-05 00.00.00 1 -405.71 02-JAN-05 00.00.00 1 -760.71 03-JAN-05 00.00.00 ref_table PRODUCT EFF_FROM_DATE EFF_TO_DATE TYPE MIN_AMT MAX_AMT CHARGE 12 01-JAN-05 00.00.00 01-JAN-06... (6 Replies)
Discussion started by: rohit_shinez
6 Replies

5. Shell Programming and Scripting

Converting a date to friday date and finding Min/Max date

Dear all, I have 2 questions. I have a file with many rows which has date of the format YYYYMMDD. 1. I need to change the date to that weeks friday date(Ex: 20120716(monday) to 20120720). Satuday/Sunday has to be changed to next week friday date too. 2. After converting the date to... (10 Replies)
Discussion started by: 2001.arun
10 Replies

6. Shell Programming and Scripting

Check if a date field has date or timestamp or date&timestamp

Hi, In a field, I should receive the date with time stamp in a particular field. But sometimes the vendor sends just the date or the timestamp or correctl the date&timestamp. I have to figure out the the data is a date or time stamp or date&timestamp. If it is date then append "<space>00:00:00"... (1 Reply)
Discussion started by: machomaddy
1 Replies

7. UNIX for Dummies Questions & Answers

Delete a row from a file if one column containing a date is greater than the current system date

Hello gurus, I am hoping someone can help me with the required code/script to make this work. I have the following file with records starting at line 4: NETW~US60~000000000013220694~002~~IT~USD~2.24~20110201~99991231~01~01~20101104~... (4 Replies)
Discussion started by: chumsky
4 Replies

8. Shell Programming and Scripting

Date One Week Ago From Given Date, Not From Current Date

Hi all, I've used various scripts in the past to work out the date last week from the current date, however I now have a need to work out the date 1 week from a given date. So for example, if I have a date of the 23rd July 2010, I would like a script that can work out that one week back was... (4 Replies)
Discussion started by: Donkey25
4 Replies

9. UNIX for Dummies Questions & Answers

derivation of the name linux?

My friend told me Linux is called linux for little unix; I dont believe thats true and iwant to tell him hes wrong, i think its called linux cuz the guy who originaly made it's first name is linus, but b4 i go and correct him; i want to get the real answer so i dont look like a idiot, ty. (4 Replies)
Discussion started by: stealthdestroyr
4 Replies
Login or Register to Ask a Question