date calculation - end month + 30 days

[Guest]

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.

 

[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.

look in the help: dateadd()

 

[Guest]

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.

 

[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.

Dateserial is your friend

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

 

[Guest]

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

 

[Andi Mayer]

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

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