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
date generation
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: