Using criteria to filter OleDB data source

[AmyM1]

I'm trying to import a selection of data from a data source. I want to select the entries with the most recent date but I don't know what to put in the criteria to filter just the most recent date. 

[kumaranvr1984]

HI Amy,

You can write sql code in sql editor to get the latest date entries.

[AmyM1]

Thanks, where do I find out how to do that?

[kumaranvr1984]

Hi Amy,

You can find it in the last tab of the table query. 

Are you trying to connect a table from SQL server or what is the source DB?

[kumaranvr1984 · Accepted solution]

Hi Amy,

Sql Query like below in sql editor

select master.dbo.Emp_subdetails.Empid,
master.dbo.Emp_subdetails.DOB
from master.dbo.Emp_subdetails
where master.dbo.Emp_subdetails.DOB = (select distinct max(DOB)from master.dbo.Emp_subdetails)

or try give date condition in criteria  filed on Visual query builder tab like below

Note: you have to give this criteria for specific field not for all fields.

Here it is DOB

= (select distinct max(DOB)from master.dbo.Emp_subdetails)

Hope this helps.

[AmyM1]

That's really helpful, thankyou!

[kumaranvr1984]

Hi Amy,

If this resolves your issue please mark this as solved.

Thanks