SQL QUERY FOR LAST DATE OF MONTH AND PARAMETER DATE

Hi Team,

need sql query for if i put middle of the month date and the last date of the month should come. if i put the last date of the month then that date will appear query Kindly help me to create query for me . Thanks