Anyone have some advice on how to tackle the following....

I'm querying an Access database, I have an FME set up that makes some 
selections based on certain factors, etc.. but what I'd like to do is 
have this FMW run every week, but when it runs, to only spit out 
records that were entered that week.
So if I set the FME to run every Monday morning, I'd like it to only 
output records entered from the previous Monday, until the day before 
(Sunday).  Is there a way to query or test and filter date fields in 
FME?
My original thinking was to use the date stamper and then just 
subtract 7 days from the stamped date, but not really sure what to do 
if the FME runs on say, Monday January 2nd (20060102).  How do I get 
it to select records entered between December 26th 2005(20051225) and 
january 1st 2006 (20060101)??

Any suggestions on how to get started are appreciated.
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/
 


Reply via email to