Sponsored Content
Top Forums Shell Programming and Scripting recurrence for every sunday for Date::MAnip in perl Post 302281655 by otheus on Thursday 29th of January 2009 08:45:27 AM
Old 01-29-2009
From the Date::Manip man pages....
Quote:
Values to the right of the asterix can be listed a single values, ranges (2 numbers separated by a dash "-"), or a comma separated list of values or ranges.
...
If the week element is non-zero and the day element is non-zero, it refers to the day of the week. It can be any value from 1 to 7 (negative values -1 to -7 are also allowed). If you use the ISO8601 convention, the first day of the week is Monday (though Date::Manip can use any day as the start of the week by setting the FirstDay config variable).
....
If the week element is zero and the month element is non-zero, the day value is the day of the month (it can be from 1 to 31 or -1 to -31 counting from the end of the month). If a value of 0 is given, it defaults to 1.
So you need a non-zero week, an asterisk, and a comma-separated list of non-zero days. I haven't tried this, but I think this would work:

0:0:1*6,7:0:0:0
 

8 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Date - Last Sunday thru Saturday

Hi All, I have to kick off a script on every Monday to get some data from database for last week (Sunday thru Saturday). If its Monday (12/12/2005) Begin date will be Sunday - 12/4/2005 End date will be Saturday - 12/10/2005 The script might not kick off on some Mondays. So my... (2 Replies)
Discussion started by: skymirror
2 Replies

2. UNIX for Dummies Questions & Answers

How to find last sunday (date) using perl?

How to find last sunday (date) using perl? Eg, If i run today (26-Feb-2008 / Tuesday), I should get 24-Feb-2008 (Sunday). Any help? (3 Replies)
Discussion started by: deepakwins
3 Replies

3. Shell Programming and Scripting

Last sunday of current date

Hi Please help me with this problem i need to find the date of last week sunday from the current given date (12 Replies)
Discussion started by: aishsimplesweet
12 Replies

4. Shell Programming and Scripting

awk to print count for chars recurrence

input: 123456 1111 124567 2222 125678 3333 234567 aaaa 456789 abcd awk logic: - read lines for recurring 1st 2 chars of the 1st field - if recurrence detected count up and print value output: 1 123456 1111 2 124567 2222 3 125678 3333 (6 Replies)
Discussion started by: ux4me
6 Replies

5. Shell Programming and Scripting

how to find out recurrence and print it.

Hi all, I have a file having data like this: rs4332761 15XB rs4332761 unk rs4571228 15XB rs457263 5XB rs4606515 10XA rs4606515 10XB rs4606515 15XB I want output like this: rs4332761 15XB,unk rs4571228 15XB rs457263 5XB rs4606515 10XA,10XB,15XB I... (2 Replies)
Discussion started by: pirates.genome
2 Replies

6. Shell Programming and Scripting

How to derive the last Sunday's date when Current date value is passed

Hi All, I have a requirement in my project where a batch runs on any day of a week. The input files will land to the server every Sunday. I need to read these files based on the current BUS_DAY (which falls any day of the week). For e.g : if the BUS_DAY is 20120308, we need to derive the... (3 Replies)
Discussion started by: dsfreddie
3 Replies

7. Shell Programming and Scripting

Fetch date of 7 years back from current date in Perl

$beginDate = substr(DateCalc("today", "-7Days"),0,8); This fetches the date 7 days back Can I fetch the date before 7 years from todays date in Perl using same syntax Use code tags, see PM. (3 Replies)
Discussion started by: parthmittal2007
3 Replies

8. UNIX for Dummies Questions & Answers

Yesterday's Date if it is Sunday

Hi All, Can you please let me know how to get the yesterday's date of the given date if the given date is Sunday? I can't use GNU. I have the code to get the yesterday's date based on the system date. Thanks (5 Replies)
Discussion started by: shash
5 Replies
Date::Manip::Holidays(3pm)				User Contributed Perl Documentation				Date::Manip::Holidays(3pm)

NAME
Date::Manip::Holidays - describes holidays and events SYNOPSIS
This describes the Holidays and Events sections of the config file, and how they are used. Holidays and events are specific days that are named. Holidays are used in business mode calculations, events are not. Events may be used for other calendaring operations. HOLIDAYS
The holiday section of the config file is used to define holidays. Each line is of the form: STRING = HOLIDAY HOLIDAY is the name of the holiday (or it can be blank in which case the day will still be treated as a holiday... for example the day after Thanksgiving is often a work holiday though it is not named). STRING is a string which can be parsed to give a valid date. It can be any of the following forms: A full date Specific holidays can be set which occur only a single time. May 5, 2000 = A one-time-only holiday Any format parseable by Date::Manip::Date::parse_date can be used. A date without a year Some holidays occur every year on the same day. These can be defined using the simple lines: Jan 1 = New Year's Day Jul 4th = Independence Day fourth Thu in Nov = Thanksgiving These dates must be written in a form which can be parsed as a full date by simply adding the year to the end of the string. Please refer to the Date::Manip::Date documentation to see what forms will work. ISO 8601 dates will not work since the year comes first. Any format parseable by Date::Manip::Date::parse_date can be used. Recurrence The dates can be specified using recurrences: 1*0:0:0:0:0:0*EASTER = Easter 1*11:0:11:0:0:0*DWD = Veteran's Day In cases where you are interested in business type calculations, you'll want to define most holidays using recurrences, since they can define when a holiday is celebrated in the financial world. For example, Christmas might be defined as: Dec 25 = Christmas but if it falls on a weekend, there won't be a business holiday associated with it. It could be defined using a recurrence: 1*12:0:24:0:0:0*DWD = Christmas so that if Christmas falls on a weekend, a holiday will be taken on the Friday before or the Monday after the weekend. You can use the fully specified format of a recurrence: 1*2:0:1:0:0:0***Jan 1 1999*Dec 31 2002 = Feb 2 from 1999-2002 OTHER HOLIDAY CONSIDERATIONS
Recurrences which change years It is now valid to have a recurrence defined for New Year's day which pushes the holiday to the previous year. For example, the most useful definition of New Year's day is: 1*1:0:1:0:0:0*DWD = New Year's Day which means to choose the closest working day to observe the holiday, even though this might mean that the holiday is observed on the previous year. Order of definitions is preserved The order of the definitions is preserved. In other words, when looking at the holidays for a year, previously defined holidays (in the order given in the config file) are correctly handled. As an example, if you wanted to define both Christmas and Boxing days (Boxing is the day after Christmas, and is celebrated in some parts of the world), and you wanted to celebrate Christmas on a business day on or after Dec 25, and Boxing day as the following work day, you could do it in one of the following ways: 1*12:0:25:0:0:0*NWD = Christmas 1*12:0:26:0:0:0*NWD = Boxing or 1*12:0:25:0:0:0*NWD = Christmas 1*12:0:25:0:0:0*NWD = Boxing Holidays go into affect the minute they are parsed which is why the second example works (though for clarity, the first one is preferable). The first recurrence defined the first business day on or after Dec 25 as Christmas. The second one then defines the business day after that as Boxing day. Since the definitions are stored as a list (NOT a hash as they were in Date::Manip 5.xx), using the same recurrence twice does not cause a problem. Multiple holidays Having multiple holidays on a single day is allowed. As an example, you may want to look at New Years day as both the observed and actual holidays, so you might have: 1*1:0:1:0:0:0*DWD = New Year's Day (observed) Jan 1 = New Year's Day Most of the time, both will fall on the same day, but sometimes they may differ. In this example, it is important that the observed holiday be listed first. Otherwise, Jan 1 will be marked as a holiday and then the observed date will check Jan 1, but where it is not a business day, it will move to another day (due to the DWD modifier). Likewise, the two holidays: 3rd Sunday in June = Father's Day Jun 17 = Bunker Hill Day sometimes fall on the same day. Using the Date::Manip::Date::list_holidays method (or the Date_IsHoliday function), you can get a list of all names that the date contains. EVENTS
The Events section of the config file is similar to the Holiday section. It is used to name certain days or times, but there are a few important differences: Events can be assigned to any time and duration All holidays are exactly 1 day long. They are assigned to a period of time from midnight to midnight. Events can be based at any time of the day, and may be of any duration. Events don't affect business mode calculations Unlike holidays, events are completely ignored when doing business mode calculations. Whereas holidays were added with business mode math in mind, events were added with calendar and scheduling applications in mind. Every line in the events section is of the form: EVENT = NAME where NAME is the name of the event, and EVENT defines when it occurs and its duration. An EVENT can be defined in the following ways: Date YMD YM Recur Date ; Date YMD ; YMD YM ; YM Date ; Delta Recur ; Delta Date refers to a full date/time (and is any string that can be parsed by Date::Manip::Date::parse). YMD is any string which can be parsed by Date::Manip::Date::parse_date. YM is any string which can be parsed by the parse_date method to give a date in the current year. Recur is a partial or fully specified recurrence. Delta is any string that can be parsed to form a delta. With the "Date" form, or the "Recur" form, the event starts at the time (or times) specified by the date or recurrence, and last 1 hour long. With the "YMD" and "YM" forms, the event occurs on the given day, and lasts all day. With all of the two part forms ("Date;Date", "YM;YM", etc.), the event starts at the first date and goes to the second date, or goes an amount of time specified by the delta. The "YMD;YMD" and "YM;YM" forms means that the event lasts from the start of the first date to the end of the second. In the Date;Date form, the event goes from the first date to the second date inclusive. In other words, both dates are in the event. In the "Date;Delta" and "Recur;Delta" forms, the Delta tells the length of the event. Also, in the Date;Date form, the second date may NOT be expressed as a delta. Currently, having an event longer than 1 year is NOT supported, but no checking is done for this. KNOWN BUGS
None known. BUGS AND QUESTIONS
Please refer to the Date::Manip::Problems documentation for information on submitting bug reports or questions to the author. SEE ALSO
Date::Manip - main module documentation LICENSE
This script is free software; you can redistribute it and/or modify it under the same terms as Perl itself. AUTHOR
Sullivan Beck (sbeck@cpan.org) perl v5.14.2 2012-06-02 Date::Manip::Holidays(3pm)
All times are GMT -4. The time now is 07:00 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy