How to get date value by variable?


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting How to get date value by variable?
# 1  
Old 02-13-2014
[Solved] How to get date value by variable?

Hello All,
I have one question:

Code:
> cat abc.txt
BrSp_IVR_Daily_Report_last_day_,date +'%Y-%m-%d',jim,969-PP-A,DAILY,/home/jim/reports/,YES
BrSp_Status_Movements_C_,date +'%Y-%m-%d',jim,969-PP-A,DAILY,/home/jim/reports/,YES

> cat akk.ksh
#!/bin/ksh
get_data()
{
OLDIFS=$IFS
IFS=","

while read fname dfrmt uname serv occr fpath toclient
do
DT=`${dfrmt}`
ssh ${uname}@${serv} -n "ls -lrt ${fpath}${fname}*${DT}*" | awk -F' ' '{print $6"-"$7"-"$8","$5","$NF}' | awk -F/ '{print $1""$NF}' 1>>xyz.txt
done < abc.txt
IFS=$OLDIFS
}
get_data

When I execute akk.ksh it fetches the data, but gives this error..
How cat I get date value in $DT variable?

Code:
date +'%Y-%m-%d': not found [No such file or directory]

I am new to UNIX.
# 2  
Old 02-13-2014
Try this instead:
Code:
#!/bin/ksh
get_data()
{
        while IFS=',' read fname dfrmt uname serv occr fpath toclient
        do
                DT=$($dfrmt)
                ssh ${uname}@${serv} -n "ls -lrt ${fpath}${fname}*${DT}*" | awk -F' ' '{print $6"-"$7"-"$8","$5","$NF}' | awk -F/ '{print $1""$NF}' 1>>xyz.txt
        done < abc.txt
}
get_data

Having IFS set to "," when you issued the command DT=`${dfrmt}` kept the space between "date" and "+'%Y-%m-%d'" from being recognized as a field splitter (so the entire string became a command name instead of date being a command name and +'%Y-%m-%d' being an operand for the date command.
These 2 Users Gave Thanks to Don Cragun For This Post:
# 3  
Old 02-14-2014
Thank you so much Don!!! It worked as I expected..
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

How to replace a parameter(variable) date value inside a text files daily with current date?

Hello All, we what we call a parameter file (.txt) where my application read dynamic values when the job is triggered, one of such values are below: abc.txt ------------------ line1 line2 line3 $$EDWS_DATE_INSERT=08-27-2019 line4 $$EDWS_PREV_DATE_INSERT=08-26-2019 I am trying to... (1 Reply)
Discussion started by: pradeepp
1 Replies

2. Shell Programming and Scripting

Convert a date stored in a variable to epoch date

I am not able to pass date stored in a variable as an argument to date command. I get current date value for from_date and to_date #!/usr/bin/ksh set -x for s in server ; do ssh -T $s <<-EOF from_date="12-Jan-2015 12:02:09" to_date="24-Jan-2015 13:02:09" echo \$from_date echo... (7 Replies)
Discussion started by: raj48
7 Replies

3. Solaris

Setting Date Variable +1 date

I need to set a date varable within ksh that will set the date to the next day in the format 25-JUL-2013 - any help would be appreciated. (3 Replies)
Discussion started by: bjdamon
3 Replies

4. Shell Programming and Scripting

LINUX ---> Add one date to a date variable

Hi All, I am trying to add one day to the busdt variable i am extracting from a file (DynamicParam.env). I am deriving the busdt as below. Is there any function which I can use to derive as below. If busdt=20120910, then the new derived variable value should be 20120911 If... (2 Replies)
Discussion started by: dsfreddie
2 Replies

5. Shell Programming and Scripting

Date into variable

I'm trying to set var j = to date like this: j = $(date +%yy%m%d) echo $j But I'm missing something here. (3 Replies)
Discussion started by: dba_frog
3 Replies

6. Shell Programming and Scripting

[ask]date variable

Is there date variable in bash? for example, I have string 01-23-2010 (mm-dd-yyyy) or 23-01-2010 (dd-mm-yyyy). How can I convert that string to date variable? and how to do some math operation based on date? for example, today is 12-11-2010. I want to know date 100 days after today or 50... (3 Replies)
Discussion started by: 14th
3 Replies

7. Shell Programming and Scripting

How to check date variable according to the current date?

Hi folks, I need to write a script that should activate a process according to the current hour. The process should be activatet only if the hour is between midnight (00:00) and 07:00. How should I create the condition? Thanks in advance, Nir (2 Replies)
Discussion started by: nir_s
2 Replies

8. Shell Programming and Scripting

convert date variable to doy variable

Hello: I have a script that requires the use of DOY (as a variable) instead of YY/MM/DD. I already obtained these parameters from downloaded files and stored them as variables (i.e. $day, $month, $year). Is there any simple script that I could incorporate in mine to do this job? Regards, ... (8 Replies)
Discussion started by: aabrego
8 Replies

9. Shell Programming and Scripting

Date variable

Dear all, Today=`date +%d%m%y`` I want to decrease the date by 1. How would we do that. Thanks. (6 Replies)
Discussion started by: asadlone
6 Replies

10. Shell Programming and Scripting

using date in a variable name

Hi, Another nubie to Unix programming. I am using the Korne shell. I am trying to use the system date as a name in a tar file. Here is the code to explain. TODAY= date +%m%d%y echo $TODAY ### it echo's 021606 which is fine tar -cvf "$TODAY".tar *.std* I think you get the idea.... (11 Replies)
Discussion started by: ppopper
11 Replies
Login or Register to Ask a Question