Get only data from the latest available date in dataset

[chvizda]

Hi all

A have a connection to a SQL database.Within is date field which shows me the receiving date.

Unfortunately over the weekend I get no new data.

In my output file I want to show every day the latest available data based on the date field.

Is there a formula / filter available to filter the data on the latest/newest date ?

Many thanks in advance

Steffen (vizda)

[kat · Accepted solution]

Hi @chvizda

Could this help?

Here we're looking for the maximum date and then joining on it, thus filtering for it.

Hope that helps

Kat

[chvizda]

Many thanks Kat.

Cool, that you help out also with such basic stuff (for you).

Steffen

[kat]

Always happy to help @chvizda

basic things are the most important... :)