date calculation - end month + 30 days

C

Clare

I have a field - ddmmyy for the date an invoice is received. I would like to
create a calculated field which is the end of the month plus 30 days, or end
of the month following.

Is there any way to turn ddmmyy into 30(mm+1)yy?

Thanks in advance.
 
A

Andi Mayer

I have a field - ddmmyy for the date an invoice is received. I would like to
create a calculated field which is the end of the month plus 30 days, or end
of the month following.

Is there any way to turn ddmmyy into 30(mm+1)yy?

Thanks in advance.
Click to expand...

look in the help: dateadd()
 
C

Clare

Cheers Andi I've now got to

=DateAdd("m",1,[DateReceived]) which works great

But I'm now not sure how to turn the days into the last day of the month.
 
A

Andi Mayer

Cheers Andi I've now got to

=DateAdd("m",1,[DateReceived]) which works great

But I'm now not sure how to turn the days into the last day of the month.
Click to expand...

Dateserial is your friend

lastOfThisMonth=dateserial(year(date),month(date)+1,0)
 
C

Clare

Cheers Andi that's solved it and I've succesfully learnt to use both dateadd
and dateserial.
 
A

Andi Mayer

Cheers Andi that's solved it and I've succesfully learnt to use both dateadd
and dateserial.
Click to expand...

your welcome, I was hoping(with the first answer) you are looking into
the help (function reference) and see what else you can find under D
as date.....
 
Top