UNIX for Dummies Questions & Answers

I need to generate a report on the first of each month that will show me how many points are going to expire on a particular scheme for the next three months. The points expiry is not an issue what I have an issue with is finding the command to give me the last day of each month for the current and the next two.

So for example if I ran the query on 1st Feb I would need...

28/02/2011
31/03/2011
30/04/2011

Obviously this will move on one month each month,

Any help would be appreciated.

Thanks

My perlish solution:

Code:

use strict;
use warnings;
use POSIX qw{ strftime };

my @T = localtime;

$T[3]  = 1;
$T[4] += shift @ARGV;
while (11 < $T[4]) { $T[4] -= 12; $T[5] +=  1; }

print strftime '%x%n', @T;

To use:

Code:

./scriptname n

Which returns the date of the first of the months for n months in the future. For example:

Code:

trogdor $ ./scriptname 17
06/01/2012

Note that %x will format the date for the current locale, which is "en_US.UTF-8" for this example.

Thanks for the swift reply but I really need this to be included in a ksh script that will run from the crontab as I need to use the dates as variables when it comes to generating the reports.

Any advice on how to do this would be great - thanks!