Finding start date and End date

[#1]

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

[Nicole-Smith · Accepted solution]

I have edited your example file.  Please see the attached.

[sunny_talwar]

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))))

[maxgro]

another one

start

=makedate(Year, div(Index('$(MonthNames)', Month), 4)+1)

end is monthend........