How do I show the first perf and the last perf in a production season?

Hi Madeline,

The best way to achieve this with a date format that you can control would be to talk to consulting about 2 custom date fields that return the first and last performance date within each production season. Alternatively, you could create a VALUE that looks like a date...

Here I've got these numeric parts of the Performance Date yielding a value in the format YYYYMM.DD. Then taking the MIN and MAX of that resulting value returns the first and last performance date within each production season:

MIN ( [Calendar Year] * 100 + [Calendar Month] + ([Calendar Day Of Month] * 0.01) )

Best,
Chris

Thanks Chris! This is great as a stop-gap. I do have one question. In your example, it brought back 201712.10 for one of the values. How do I make sure that the 0 is at the end? When I ran this one of my values came back as 202004.3 and it should have a 0 at the end.

Madeline Dummerth (Past Member)

Is the date you are showing here is 4/30/2020 (as written here in the states)? Have you checked the formatting to see if you can force the system to display 2 decimal points? 

Madeline Dummerth (Past Member)

Is the date you are showing here is 4/30/2020 (as written here in the states)? Have you checked the formatting to see if you can force the system to display 2 decimal points? 

haha - boy do I feel silly! Yep - that solved it!

I like your question.  I've had blind spots like this in the past.

I'd like to thank you for asking.  We now have a more complete description here on how to make this work.

--Tom