Max Date/Script

Report Inappropriate Content · ‎2013-08-30

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 · ‎2013-08-30

Hi

Try like this

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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

tresB · ‎2013-08-30

PFA