Please help me out

[katta_nikhil]

CIV Patient Schedule (5).xlsx (5.9 KB)

This attachment consists of excel and i want only pending status… which is date is latest date…

and some times date is in the format of OA date and some times it is in the fomat of norml date “MM/dd/yyyy”

so consider both cases i want only the latest date

please do and send me the xaml file

Thanks you

[Yoichi]

Hi,

How about the following?

Sample20230626-8L.zip (7.6 KB)

Regards,

[katta_nikhil]

thanks
thank you so much