To show latest record in straight table

[sunitha_chellaiah]

Hi All,

I want to show only latest record in my table.

For eg:

In my attachment there are multiple records are appearing against PO Number '16303383' at different date and time. I want only the latest record that is,  for date&time '26-7-2017152532' record to be shown in report.

Note: I have concatenated Date&Time field in the front end    :   =max([POUPMJ - Date - Updated])&''&max([POOPRT -time])

[tresesco]

FirstSortedValue() should be what you need here.

[sunitha_chellaiah]

It's not working

[Anil_Babu_Samineni]

Can you please post sample in excel file instead Image. And please post expected result set as well to better understand

[sunitha_chellaiah]

Hi,

I have attached one sample file.

Output should show only latest record based on date and time.

i.e.

17302687 GR BDET 117360 105140

[Anil_Babu_Samineni]

PFA

[sunitha_chellaiah]

Hi,

Can you please share the application. 

how did you make DateTime field

[Anil_Babu_Samineni]

Load *, Date&Time as DateTime ....

[sunitha_chellaiah]

Hi,

Can you please try for this attached data. I am not getting the desired output. 

[Anil_Babu_Samineni]

What is the expected result POTDAY ??