Newbies NongWa Posted April 13, 2010 Newbies Posted April 13, 2010 Hi I have many sell records which start from 1 feb 2009, until now I want to count no. of month(it should be 15 months) in the calc. field but I don't know what function should be used. By using month(date), I face the problem of different year and can't count month. I need your help. Thanks.
comment Posted April 13, 2010 Posted April 13, 2010 Try = 12 * ( Year ( Get(CurrentDate) ) - Year ( StartDate ) ) + Month ( Get(CurrentDate) ) - Month ( StartDate ) - ( Day ( Get(CurrentDate) ) < Day ( StartDate ) )
Recommended Posts
This topic is 5396 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now