Page 1 of 1

Calculate First of Next Month

Posted: Fri Apr 05, 2002 12:27 pm
by Ward_(Guest)
I need to calculate the first day of the next month {MM/01/YYYY} from a date field {MM/DD/YYYY}. Is their an easy way to do this?____

=> RE: Calculate First of Next Month

Posted: Fri Apr 05, 2002 1:05 pm
by kfleming
There are lots of ways to get there but I generally use:____Addmons(datefield,1)-Day(Addmons(datefield,1))+1____Kathleen__R&R Support

==> RE: Calculate First of Next Month

Posted: Fri Apr 05, 2002 1:42 pm
by Ward_(Guest)
Thanks!!!__