first and last days

[sal21]

Admit have a var ANNO="2010" and var MESE="11"
how to calculate the first and last day of this date and assign a value in var FIRST_DAY and in var LAST_DAY

In this case:
FIRST_DAY="01/11/2010"
LAST_DAY="30/11/2010"

[HansV]

Are FIRST_DAY and LAST_DAY string variables, as the quotes suggest, or are they date variables?

[sal21]

Are FIRST_DAY and LAST_DAY string variables, as the quotes suggest, or are they date variables?

string var...

[HansV]

Here you go:

FIRST_DAY = Format(DateSerial(ANNO, MESE, 1), "dd/mm/yyyy")
LAST_DAY = Format(DateSerial(ANNO, MESE + 1, 0), "dd/mm/yyyy")

[sal21]

Here you go:

FIRST_DAY = Format(DateSerial(ANNO, MESE, 1), "dd/mm/yyyy")
LAST_DAY = Format(DateSerial(ANNO, MESE + 1, 0), "dd/mm/yyyy")

sorry me for delay...
Work fine tks.