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])

[sunitha_chellaiah]

POTDAY is nothing but Time only.

Expected result is

17300889  RTSA  REL  117180  84959

See the attached update file.

[Anil_Babu_Samineni]

PFA