Skip to main content
  • EN

I am reading data from a file geodatabase in my workspace. The data is huge and takes time to process data. I have set up a query to only filter data that ends with .2022 but the workspaces are still slow.image 

Therefore, I intend to set up a query on a Date Modified column and a Create date column in the file geodatabase. This will filter only data modified and created within the last seven days. I can't figure out how to set up a query and filter data from the last seven days in FME.

 

Any help and advice would be greatly appreciated.

 

Thank you,

 

Are you asking how to use a date query in a gdb reader?

Are you asking how to use a date query in a gdb reader?

yes

So I'd probably do something like get FME to calculate the date 7 days ago, then use a featurereader to read the gdb and use something like this in the where clause

FORMAT(DATEMODIFIED, 'yyyyMMdd') >= @Value(last_7_days)

 

 

Reply


Community Stats

30,167
Posts
114,520
Replies
37,824
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.