Max Date/Script

[#1]

Hi All,

Attached is an excel with the fields,

Date    Field1   Field2

I want to get the maximum date for EACH MONTH where Field1 is not zero.

If you see the excel, i want

8/17/2013

and

9/13/2013

.I have more than 30 months in my data.Is it possible to get these max dates in a particular field in the script?Or any other solution will help.

Thanks and Regards,

Pavan

[MayilVahanan]

Hi

Try like this

If(Field1 <> Previous(Field1) and Field1 = 0, Previous(Date)) as Date

[tresesco]

PFA