DSXchange

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

please refer to this post:

viewtopic.php?t=101880

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