Getting the last day from a date field

I have a date field spaning several days, it displays the first and last day and I want to be able to extract the last day. I currently do it using several fields which is cumbersome and wondered if anyone has a “clean” way of doing his?

Hello John,

Check out below.
Knack. Let me know if you need the same.

Sunny Singla

Hi Sunny

Thanks for your response.

That would be very handy, just what I was after provided its not to cumbersome.


Hello John,

If that work for you then you can go to the link below for detail.

Sunny Singla