date generation

sundar · Post by **sundar** » Tue Jul 11, 2006 2:24 am

Hi all
I had two date fields valid_from and valid_to having values 29-5-2005 and 5-6-2005.
i want to generate records for dates between these two fields like
29-5-2005
30-5-2005
31-5-2005
01-06-2005
02-06-2005
03-06-2005
04-06-2005
05-06-2005

if it is saturday or sunday, it should not generate record for the date.
I tried using transformer and functions.

Please help me in this regard.

with regards
sundar

bchau · Post by **bchau** » Tue Jul 11, 2006 2:37 am

please refer to this post:

viewtopic.php?t=101880

ray.wurlod · Post by **ray.wurlod** » Tue Jul 11, 2006 5:14 am

It's probably easier to generate all dates (Column Generator stage) then remove those whose day of week is Saturday or Sunday (Filter stage).