Calculate First of Next Month

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
Ward_(Guest)
Posts: 2
Joined: Tue Oct 10, 2017 12:44 pm

Calculate First of Next Month

Post by Ward_(Guest) » Fri Apr 05, 2002 12:27 pm

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?____
Top
kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: Calculate First of Next Month

Post by kfleming » Fri Apr 05, 2002 1:05 pm

There are lots of ways to get there but I generally use:____Addmons(datefield,1)-Day(Addmons(datefield,1))+1____Kathleen__R&R Support
Top
Ward_(Guest)
Posts: 2
Joined: Tue Oct 10, 2017 12:44 pm

==> RE: Calculate First of Next Month

Post by Ward_(Guest) » Fri Apr 05, 2002 1:42 pm

Thanks!!!__
Top
Post Reply

Return to “R&R ReportWorks Users”