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.
Solved! Go to Solution.
HI Amy,
You can write sql code in sql editor to get the latest date entries.
Thanks, where do I find out how to do that?
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?
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.
That's really helpful, thankyou!
Hi Amy,
If this resolves your issue please mark this as solved.
Thanks