How to use MAX() function with date field

[Former Member]

Hi Frzz,

I have created a Graphical calculation view in which i have multiple records for each employee with different dates. But my requirement is to take the records which have maximum date.

I have converted the date into Integer and applied the MAX() function. But still am getting multiple records.

Is there is any other way we can achieve this requirement in Graphical Calculation view??  Your suggestion will really help me.

Thank  you.

Krishna.

[Former Member · Accepted solution]

Actually i have aggregated the date field with MAX after converting it into integer.

[Former Member · Accepted solution]

Date values are like

20140101

20140102

20140103

20140104

[former_member182302 · Accepted solution]

Have an aggregation node and keep only date as the column and use max for it. And then try to join this aggregation node with your result table.

Then it will give the records with max date only.

Regards,

Krishna Tangudu

[Former Member · Accepted solution]

Hi Krishna,

Thanks for the update.

If i use aggregation node and use max for the Date filed, In this case which fieds act as the Group By claue?? All the remaining fileds are under Group By Clause???

Best Regards,

Krishna.

[former_member182302 · Accepted solution]

Hi Krishna,

Only add DATE filed add it as "Aggregated column" and use MAX for it.

It will frame a query something similar to this: SELECT MAX(DATE) FROM TABLE

Regards,

Krishna Tangudu

[Former Member · Accepted solution]

Thanks a lot krishna.

Its working.

[Former Member · Accepted solution]

can you please elaborate?