Excel date issue

Hi iam trying to get the latest excel date in the excel file using the max query … But my excel is showing as the excel coloum like this …

@Nikhil_Katta

Can you please specify what error is it…bacause excel is read as columns

Cheers

See the excel date format …

@Nikhil_Katta

Are you talking about date?

If so use preserve format option or display value option

Cheers

Did you try with this?

image

I tried preserve format

grafik

Can u share the code

was done in the immediate panel
Understanding the 6 Debugging Panels of UiPath in the easiest way possible! - News / Tutorials - UiPath Community Forum

You can use it e.g. within an assign activity