date calculation - end month + 30 days

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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()
 
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.
 
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)
 
Cheers Andi that's solved it and I've succesfully learnt to use both dateadd
and dateserial.
 
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.....
 
Back
Top