Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends,
Please let me know if any one can Help in Finding start date and End date of the selected month, For the Attached QVW file.
Regards,
Pooja
I have edited your example file. Please see the attached.
I have edited your example file. Please see the attached.
This?
Expressions:
start date
=Date(MakeDate(Min(Year),Min(Month(Date#(Month, 'MMM'))), 1))
End date
=Date(Floor(MonthEnd(MakeDate(Min(Year),Min(Month(Date#(Month, 'MMM'))), 1))))
another one
start
=makedate(Year, div(Index('$(MonthNames)', Month), 4)+1)
end is monthend........