First date of a data set but of the current year

[magellan]

Hello,

I have a set of data which contains dates reaching from 01-03-2024 to 30-03-2024 and various dates in 2023.

Now I need to get the first date out of my data set but out if this year. This would be 01-03-2024.

When I use min(), minstring(), makedate() the result is either 01-01-2024 or the first date in the data which is some day in 2023.

Is it possible somehow to get the desired 01-03-2024?

[BrunPierre]

@magellan I didn't fully grasp it initially, perhaps this.

=Min({<[Date Field]={"$(=Date(MonthStart(Max([Date Field] )), 'DD-MM-YYYY'))"}>} [Date Field])

[steeefan]

LOAD
  Min([Date Field]) AS MinDate
FROM
  DateTable
WHERE
  Year([Date Field]) = Year(Today());

[magellan · Accepted solution]

Thanks to everyone.
I solved this using the following expression:

=date(FirstSortedValue ({< [Date.autoCalendar.Year] = {$(=year(today()))}>} distinct [Date], [Date]))