Thanks Peter and Paul, for your suggestions, I'm going to give them a
try.
I was able to figure out a way using straight FMW however. I used a
combination of the Date formatter to change dates to 'day of the year'
numbers, then just used the ExpressionEvaluator to subtract 7 from the
timestamped date, and then select records in the Access database whose
date of entry value converted to 'day of the year' was greater that
the current date minus 7.
Although, as I write this, I realise I'll have to run the first week
of each year manually, because the math won't work properly....
Anyway, it's a little clunky, but I'm basically just looking for a
weekly summary
report of events that happened or were entered the week before. Does
the trick for now...
Thanks again for your suggestions - looking forward to trying them out.
Steve
Get the maximum benefit from your FME, FME Objects, or SpatialDirect via our
Professional Services team. Visit www.safe.com/services for details.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/fme/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
