Question

Filter Date columns in file geodatabase

fme_can_do_it
Rank
Badge +8

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,

 

3 replies

ebygomm
Rank
Userlevel 1
Badge +21

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

fme_can_do_it
Rank
Badge +8

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

yes

ebygomm
Rank
Userlevel 1
Badge +21

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

28,725
Posts
109,520
Replies
36,565
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.