Joined: 06 Mar 2010
Online Status: Offline
Posts: 7
Topic: Formula help: next month Posted: 29 Apr 2018 at 8:48pm
Is there an formula what gives me the first day of the next month after a DB-date?
In the Database is a datefield, i have to count a marge of 30 days with the formula dateadd(d, 30, {db-field})
After this function i need to calculate the next first day of the next month.
For example: DB-field = 24-04-2018
With a marge of 30 days gives me: 24-5-2018
And Now i need als result 1-6-2018.
A other example: DB-field = 05-11-2018
With a marge of 30 days gives me: 05-12-2018
And Now i need als result 1-1-2019.
I’ve tried the function dateserial() , but then i have a problem by passing a new year....
Who van help me?
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum