× Discuss on Template programming, jBASE programming, Enquiries, No-File enquiry, Enquiry routines, Version, Version routines, Menus, Abbriviations, Creating local reference fields, Fast path enquiries, Creating charts and graphs, Generating Reports, Deal slips, Straight through processing, Multi Company and Multi Book setup, Tabbed screens, Composite Screens, T24 API, etc...

To find the number of month between two given days

  • t24praveen
  • Topic Author
  • Offline
  • New Member
  • New Member
More
12 years 8 months ago #8264 by t24praveen
Hi,

Any once can tell me is there any direct funtion in jBase to find the number of months between two given days Like CDD which gives the number of days.

Please Log in or Create an account to join the conversation.

More
12 years 8 months ago #8268 by Hanumanth
Hi,

Try using EB.NO.OF.MONTHS(START.DATE,END.DATE,1)

will return no:of months between start date and end date.

Cheers

Please Log in or Create an account to join the conversation.

More
8 years 4 months ago #18430 by baskarjay
its not working buddy

Please Log in or Create an account to join the conversation.

More
8 years 3 months ago #18509 by Mallika
Hi,
EB.NO.OF.MONTHS(START.DATE,END.DATE,Y.MONTHS) its working fine. In this START.DATE, END.DATE are incoming parameters and Y.MONTHS is out going parameter, u can give initially null(i.e,Y.MONTHS = '')

Please Log in or Create an account to join the conversation.

More
8 years 2 months ago #18799 by baskarjay
NOT WORKKING BUDDY

Please Log in or Create an account to join the conversation.

  • jpb
  • jpb's Avatar
  • Offline
  • Moderator
  • Moderator
  • TAFj-R20 - 'unix'
More
8 years 2 months ago #18801 by jpb
EB.NO.OF.MONTH is a routine, not a function. You have to CALL it
START.DATE = "20150513"
END.DATE   = "20160127"
V$MONTH = 1       ;*  '' or 0 => no process of broken month 
                  ;*  1       => process broken month
CALL EB.NO.OF.MONTHS(START.DATE,END.DATE,V$MONTH)
CRT "RESULT " : V$MONTH

Will return 9 month. If launched with V$MONTH = 0 then 8 is returned.
The following user(s) said Thank You: baskarjay, K.Bishay

Please Log in or Create an account to join the conversation.

More
6 years 6 months ago #21358 by baskarjay
Thank you so much All :)

Please Log in or Create an account to join the conversation.

Time to create page: 0.117 seconds