Hi All,

I am trying to print the dates that falls between 2 date variables into a file. Here is the example.

$BUS_DATE =20120616
$SUB_DATE=20120613

Output to file abc.txt should be : 20120613,20120614,120120615,20120616

Can you pls help me accomplish this in LINUX.

Thanks
Freddie

This should be a piece of cake if you know perl...

Hi Shamrock,

Our environment doesn't support PERL.

Is there a way we can accomplish this in LINUX coding

Thanks
Freddie

If you have either GNU or AT&T AST's date command, then something like this is possible:

#!/usr/bin/env ksh

date1="20120601"
date2="20120614"

ndays=$(( ($(date -d $date2 "+%s") - $(date -d $date1 "+%s"))/ 86400 ))
fmt="%s"
for x in {0..$ndays}
do
    printf $fmt "$( date -d "$date1 + $x day" "+%Y%m%d" )"
    fmt=",%s"
done
printf "\n"

for x in $( seq 0 $ndays)

You mean perl isnt installed...there is a big difference between not installed and not supported and i think there isnt a linux distro that doesnt support perl...talk to your sysadmin and [s]he can install perl for you.
What Linux distro are you running...as the date command on linux systems is very powerful unlike the one on older unix systems.

Using ksh93

date1="20120601"
date2="20120614"

u1=$(printf "%(%s)T" "${date1:0:4}-${date1:4:2}-${date1:6:2}")
u2=$(printf "%(%s)T" "${date2:0:4}-${date2:4:2}-${date2:6:2}")

fmt=""
while (( u1 < u2 ))
do
    printf "%s%(%Y%m%d)T" "$fmt" "#$u1"
    (( u1 += 3600*24 ))
    fmt=", "
done
printf "\n"