[RESOLVED] Help in MS SQL 7....Date

[preethi_rjs]

hi,

in Text1 i'll b giving Year.

in Text2 i'll b giving month(in number format.eg: 02 - Feb.)

when Text3 gets Focus, i need 28/02/2007. (Last date for the month entered in "dd/mm/yyyy" format).

i need this using MS SQL 7.