Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi Kaushik,
Thanks for your reply.
Can you tell me which delimiter should I use to get proper O/P fields.
Regards,
Kumar
I got solution.
If you have got the solution , close this thread by marking correct answer
Hi,
you can try the expression given below:
=max(date(HireDate,'DD/MM/YYYY'))