- Forum
- T24 Technical Discussions
- T24 Development & Customization
- To find the number of month between two given days
×
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
Less
More
- Posts: 2
- Thank you received: 0
12 years 8 months ago #8264
by t24praveen
To find the number of month between two given days was created 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.
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.
- Hanumanth
- Offline
- New Member
Less
More
- Posts: 10
- Thank you received: 0
12 years 8 months ago #8268
by Hanumanth
Replied by Hanumanth on topic Re: To find the number of month between two given days
Hi,
Try using EB.NO.OF.MONTHS(START.DATE,END.DATE,1)
will return no:of months between start date and end date.
Cheers
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.
- baskarjay
- Offline
- Senior Member
Less
More
- Posts: 48
- Thank you received: 0
8 years 4 months ago #18430
by baskarjay
Replied by baskarjay on topic Re: To find the number of month between two given days
its not working buddy
Please Log in or Create an account to join the conversation.
- Mallika
- Offline
- Junior Member
Less
More
- Posts: 23
- Thank you received: 2
8 years 3 months ago #18509
by Mallika
Replied by Mallika on topic Re: To find the number of month between two given days
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 = '')
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.
- baskarjay
- Offline
- Senior Member
Less
More
- Posts: 48
- Thank you received: 0
8 years 2 months ago #18799
by baskarjay
Replied by baskarjay on topic Re: To find the number of month between two given days
NOT WORKKING BUDDY
Please Log in or Create an account to join the conversation.
- jpb
- Offline
- Moderator
- TAFj-R20 - 'unix'
Less
More
- Posts: 2854
- Thank you received: 649
8 years 2 months ago #18801
by jpb
Replied by jpb on topic Re: To find the number of month between two given days
EB.NO.OF.MONTH is a routine, not a function. You have to CALL it
Will return 9 month. If launched with V$MONTH = 0 then 8 is returned.
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.
- baskarjay
- Offline
- Senior Member
Less
More
- Posts: 48
- Thank you received: 0
6 years 6 months ago #21358
by baskarjay
Replied by baskarjay on topic Re: To find the number of month between two given days
Thank you so much All :)
Please Log in or Create an account to join the conversation.
- Forum
- T24 Technical Discussions
- T24 Development & Customization
- To find the number of month between two given days
Time to create page: 0.117 seconds