Logic1

[smilingjohn]

Hi Expertise

PLease find the attachment of the qvw file .

I want to create a variable or is there a way to show the count of months for maximum Create field ...

for exmaple in Create field the data is till NOvemeber 2017.

therefore the filter should show me  11 ...how do i achieve this ?

this should be for maximum Create Field only ...

Thanks

[Anonymous]

Hi John

   You may need to use

Load max(month(Created)) as Max_Month,

        Key

From your table_name

group by Key

-Jai

[PrashantSangle · Accepted solution]

In variable write

=Month(max(dateFieldName))

Regards,