Best way to increment weeks based on fiscal start year Post: 303005798

Sponsored Content

Top Forums UNIX for Beginners Questions & Answers Best way to increment weeks based on fiscal start year Post 303005798 by Don Cragun on Monday 23rd of October 2017 12:36:11 PM

10-23-2017

Registered User

Hi SIMMS7400,
In post #51 in your earlier thread (Parsing a column of text file - best practices) I gave you code that contains a function (findSaturdayOnOrBefore()) that finds the 1st Saturday on or before a date given to it as an argument. Since it worked for me when I was testing it and you never said that it didn't work for you, I assumed that it worked for you (although you haven't acknowledged seeing that post).

Can't you use that function to determine the 1st Saturday on or before 10/07/YYYY? Isn't the result returned by that function the first day of a fiscal year for your customer? Can't you then find the first day of the next fiscal year using that function with 10/07/$((YYYY+1)) as the argument. And then, can't you add one week to the first day in a fiscal year in a loop until you hit the 1st week of the next fiscal year saving the 52 or 53 values you get in that loop as the start of the 52 or 53 weeks in that fiscal year?

Why don't you try doing this on your own, show us what you come up with, and let us know if you get stuck?

PS: Is 10/07/2017 the first day of your customer's FY2017 or is it the first day of FY2018?

PPS: Note that we are here to help you learn how to use the tools on your UNIX or UNIX-like system to write code that makes it do what you want it to do. We are not here to act as your unpaid programming staff.

Don Cragun

View Public Profile for Don Cragun

Find all posts by Don Cragun

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How many weeks in a year

Hi, I search how i could do to find if a year (for example 2004, 1989, 2058) has 52 or 53 weeks... Have you a idea for me please???

2. Solaris

Number of files - in start of year

Is there any way to find "Number of files" that exists on my solaris parition in the starting of 2009 year ? I know ctime or mtime will not help and unix wouldnt store creation time. Only hope i can see ( and i am not sure if that will help ) is that my system is up from last 2 years without...

3. Shell Programming and Scripting

how to increment days according to year & month

Hiii i have a file with data as shown below: a.dat: RAO 1900 2 7 0 0 0.00 10.8000 76.8000 10.0 0 0.00 0 6.00 0.00 0.00 0 0.00 6.00 0 NULL LEE 1901 2 15 0 0 0.00 26.0000 100.0000 0.0 0 0.00 0 0.00 0.00 0.00 0 6.00 6.00 0 NULL RAO 1901 4...

4. Shell Programming and Scripting

My PM has told me to learn shell scripting in 2 weeks , how should I start?

My PM has told me to learn shell scrting in 2 weeks , how should I start?:confused::confused::confused::confused:

5. Shell Programming and Scripting

Value Increment based on count

Hi All, I have source file x.txt 0001|0003 0031|0031 0045|0049 My desired output should be: y.txt 0001 0002 0003 0031 0045 0046 0047

6. Shell Programming and Scripting

How to calculate the total number of weeks from a specify year?

Hi anyone can help? How to calculate total number of weeks from a specify date, for example, 01 Jan 2012. Thx!

7. Shell Programming and Scripting

Create new file with increment column based on conditions

Hello, Using bash script, i need to process the following file: 887,86,,2013-11-06,1,10030,5,2,0,200,, 887,86,,2013-11-05,1,10030,5,2,0,199,, 887,138,,2013-11-06,1,10031,6,2,0,1610612736,, 887,164,,2013-11-06,1,10000,0,2,0,36000,, and to create a new file such as the below ...

8. Shell Programming and Scripting

Increment with awk - how to define start value

Hello, I am running under ubuntu18.04 My question is about awk. inputfile 0wo010011oasasds sdjhsdjh=, u12812888 8jsjkahsjajnsanakn akjskjskj=, suhuhuhwx kskkxmsnnxsnjxsnjxsnjjnjjdi=, 22878ssssss Below code adds consecutive numbers when string = is found run_code: awk -F'=' -v OFS='='...

9. Web Development

Color a Badge Based on the Weeks the Member is Active in the Latest Sequence

Hi Ravinder, Could you (and anyone else who wants to help out) check this PHP code and confirm it does what I expect it to do, which is to color a badge based on the weeks a member is active in the latest sequence? I did a cut-paste-change from my "days in sequence" PHP prototype script and it...

10. UNIX for Beginners Questions & Answers

Splitting week start date and end date based on custom period start dates

Below are my custom period start and end dates based on a calender, these dates are placed in a file, for each period i need to split into three weeks for each period row, example is given below. Could you please help out to achieve solution through shell script.. File content: ...

LEARN ABOUT LINUX

let

let(1)                                                             User Commands                                                            let(1)

NAME

       let - shell built-in function to evaluate one or more arithmetic expressions

SYNOPSIS

   ksh
       let arg...

DESCRIPTION

   ksh
       Each arg is a separate "arithmetic expression" to be evaluated.

EXIT STATUS

       The following exit values are returned:

       0        The value of the last expression is non-zero.

       1        The value of the last expression is zero.

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE         |      ATTRIBUTE VALUE        |
       +-----------------------------+-----------------------------+
       |Availability                 |SUNWcsu                      |
       +-----------------------------+-----------------------------+

SEE ALSO

       ksh(1), set(1), typeset(1), attributes(5)

SunOS 5.10                                                          15 Apr 1994                                                             let(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How many weeks in a year

Discussion started by: Castelior

2. Solaris

Number of files - in start of year

Discussion started by: rajwinder

3. Shell Programming and Scripting

how to increment days according to year & month

Discussion started by: reva

4. Shell Programming and Scripting

My PM has told me to learn shell scripting in 2 weeks , how should I start?

Discussion started by: manalisharmabe

5. Shell Programming and Scripting

Value Increment based on count

Discussion started by: kmsekhar

6. Shell Programming and Scripting

How to calculate the total number of weeks from a specify year?

Discussion started by: rayray2013

7. Shell Programming and Scripting

Create new file with increment column based on conditions

Discussion started by: JonhyDeep