difficult get value max date from datetime column

[Anonymous]

Hi,

My qvd data is coming form txt file and I want to get a max date from Record_Updated_Datetime. But when I try I get this value for particular column I am not able to select datetime column. I am getting concatebate of all columns. Please refer below screen shot.

But when I try to put that column in text object in throwing as bad fields name.

Please help me on this how to get max date on this column.

Regards,

Kumar

[kaushiknsolanki]

HI,

This means that your data is not loaded properly. Make sure that you have used correct delimiter while loading the data.

Regards,

Kaushik Solanki

[Anonymous]

Hi Kaushik,

Thanks for your reply.

Can you tell me which delimiter should I use to get proper O/P fields.

Regards,

Kumar

[Anonymous]

I got solution.

[avinashelite]

If you have got the solution , close this thread by marking correct answer

[Anonymous]

Hi,

you can try the expression given below:

=max(date(HireDate,'DD/MM/YYYY'))