filter based on a long date (datetime)

[Wajdi]

Hello Guys ,
i have the below query setting  i want only to filter (most recent date time received) the most recent datetime based a long dateformat (time included),below a screenshoot for better comprehension 

[Wajdi]

Hi @Anonymous and @HotChilli 
i applied the suggestion from @HotChilli  and it's working prefectly,thank you both 🙂 

[Anonymous]

Hi @Wajdi ,

Not very clear about this description :based a long dateformat (time included)

Do you always want to only keep the latest received date and remove other rows? If so , please follow @HotChilli 's suggest , if not, please share more details about your expected to help us clarify your scenario.

Best Regards,
Eyelyn Qin

[HotChilli · Accepted solution]

Is it always going to be one file? If so, sort the column descending and use 'Keep top rows'->1