Calculate vminDate and MaxDate from user selected Year

ashmitp869 — Thu, 15 Apr 2021 00:42:17 GMT

Hi All,

I need to create variable : the min and max date when any Reporting Date.Year is selected.

Say for example, when selecting Reporting Date.Year as 2021

The variable vMinDate should be min date of the Reporting Date.Year = 2021

and vMaxDate should be max date of the Reporting Date.Year = 2021

Regards

Re: Calculate vminDate and MaxDate from user selected Year

MayilVahanan — Thu, 15 Apr 2021 02:59:37 GMT

Try like below

vMinDate = Min(Date)

vMaxDate = Max(Date)