Select the recent date record by Lookup function

Like (0) Share

Report

Posted on 12 May 2022 07:18:43 by venka91

1,118

Hi there,

In my List for a diary farm, i have a animal details with its tag. In a dashboard i would like to show when the animal was last calved.

So i am trying to search the animal record by its tag.

In my OK button, i have written this code.

Set(varAnimalRec, Lookup(myDiary, ear_tag=txt_tagno.Text)

This is giving me the result as below.

Now from this result, i want to see when the animal was last calved.

I have column "Calving Date" as a Date and Time column, which holds the date of calving.

Now i want to filter this result with latest calving date.

Can anyone help how to i filter the lookup result based on latest calving date ?

Categories:

All responses (1)

Answers (1)