How to get the weekday of the given date?


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting How to get the weekday of the given date?
# 8  
Old 12-16-2005
Hi all,

Thank you very much for your prompt responses.
I got some solution in the net its working fine in my desktop(windows 2000) with cygwin, but its giving bailing error in my server(Sun OS 5.8).
Could any one of you help me to solve the problem, the code is below.


#!/bin/ksh

dte='2003-06-11'

eval $(echo "${dte}" | awk -F- '{printf("year=%s month=%s day=%s\n", $1, $2, $3)}')

echo "year->[${year}] month->[${month}] day->[${day}]"

cal "${month}" "${year}" | awk -v day="${day}" '
FNR > 2 {
for(i=1; i <= NF; i++)
if ( $i == day) {
#printf("day->[%d] row->[%d]\n", $i, FNR-2)
printf("%d\n", (NF == 7 || FNR!=3) ? i-1 : i+(6-NF))
exit
}
}
'


Thanks in Advance
Rinku
# 9  
Old 12-16-2005
use 'nawk' instead of 'awk' on Solaris.
# 10  
Old 12-18-2005
MySQL it works sir...

Quote:
Originally Posted by Perderabo
Should Jan 1 be a zero or a one? Both schemes are in use.

Compute the mjd of January 1 for the year. (Should Jan 1 be 1? If so subtract one.) Subtract the result from the mjd of the date to get day-of-year.

thanks Perderabo....datecalc is the real answer to all date manipulations....
# 11  
Old 10-31-2008
I wonder : Is there a way in a KSH shell what the yesterdays last business day is:
so for instance monday 03112008 (ddmmyyyy) should be give 31102008.
I've search this site but couldn't found something. Did also tried with Julians Day

I'm using AIX 5.2.0 with KSH shell pls give me a hand
# 12  
Old 10-31-2008
Code:
$ cat yesterbusinessday
#! /usr/bin/ksh

alias datecalc=./datecalc
echo "Enter year month day"
read year month day

if (($(datecalc -d $year $month $day) == 1)) ; then
        offset=3
else
        offset=1
fi
datecalc -j $(($(datecalc -j $year $month $day) - offset))
exit 0
$ ./yesterbusinessday
Enter year month day
2008 11 3
2008 10 31
$ ./yesterbusinessday
Enter year month day
2008 10 31
2008 10 30
$

# 13  
Old 10-31-2008
thx Perderabo for the fast reply ,

but i got a problem with the
# ./yesterbusinessday
+ alias datecalc=./datecalc
+ echo Enter year month day
Enter year month day
+ read year month day
2008 11 3
+ ./datecalc -d 2008 11 3
./yesterbusinessday[7]: ./datecalc: not found.
+ (( == 1 ))
./yesterbusinessday[7]: == 1: 0403-057 Syntax error
Smilie
Sorry i'm new
# 14  
Old 10-31-2008
I don't have an AIX ksh to test so I can't help you there. As for datecalc, the second post in this thread links to it.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 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. Shell Programming and Scripting

[ksh] Weekday a week ago

Hi, Using TZ and date gives an easy way to find out the dates one or more days ago. Now I am in need of knowing the date one week ago. So, now is Thursday and I want to know the date on Thursday a week ago. Unfortunately I can only get as far back as 6 days ago When using TZ+168 it reverts... (7 Replies)
Discussion started by: ejdv
7 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

yesterday's "weekday" date

i've been going through https://www.unix.com/answers-frequently-asked-questions/13785-yesterdays-date-date-arithmetic.html to find a cmd that will print me yesterday's date. I have found one that does it nicely set YEST = `date '+20%y/%m/%d' | awk -F"/" '{print $1$2($3-1)}'` as you can... (3 Replies)
Discussion started by: jack.bauer
3 Replies

7. Shell Programming and Scripting

Writing a script to run weekly/monthly - check for weekday or day-of-the-month

Hi all, I currently have a UNIX file maintenance script that runs daily as a cron job. Now I want to change the script and create functions/sub inside it that runs on a weekly or monthly basis. To run all the scripts' daily maintenance, I want to schedule it in cron as simply maint.sh... (1 Reply)
Discussion started by: newbie_01
1 Replies

8. Shell Programming and Scripting

get weekday based on date

Hi all, i am looking for a method of determining the weekday when date is know (bash, if possible). Let's say that i am looking to get the weekday for MAY 01 2011, how can i convert this into Sunday or SUN? any suggestions? (4 Replies)
Discussion started by: gigagigosu
4 Replies

9. 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

10. UNIX for Dummies Questions & Answers

[kornshell] Getting the next weekday date

Hi All can anyone help me with this, Im new to kornshell scripting and is trying to get the next weekday to a variable: strDate=%date '+%Y%m%d' // YYYYMMDD strNewDate= :confused: // assuming that current date is 20050812 (friday) then strNewDate will get 20050815 (monday) or if... (1 Reply)
Discussion started by: rs_f01
1 Replies
Login or Register to Ask a Question