RTN LAST.DAY.OF.THIS.MONTH

  • realfunny
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 29
  • Thank you received: 0

realfunny created the topic: RTN LAST.DAY.OF.THIS.MONTH

Dear all
Have everybody got source code of routine LAST.DAY.OF.THIS.MONTH ? I need to setup Frequency.
Thank you./.
#20952

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

  • Posts: 2843
  • Karma: 512
  • Thank you received: 645

jpb replied the topic: RTN LAST.DAY.OF.THIS.MONTH

If you want to write a new routine to be used in EB.FREQUENCY - SPECIAL.ROUTINE you just have COMI as in- and output, no further parameters.

Some people feel the rain - others just get wet (Bob Marley)
#20954

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

  • realfunny
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 29
  • Thank you received: 0

realfunny replied the topic: RTN LAST.DAY.OF.THIS.MONTH

Thank you, But I want to the frequency appear like the pic
#20957

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

  • Posts: 25
  • Karma: 1
  • Thank you received: 6

madhulatha replied the topic: RTN LAST.DAY.OF.THIS.MONTH

CALL core routine
CALL AM.GET.MONTH.LAST.DATE(PROCESS.DATE,MONTH.END,RESV.1,RESV.2,RESV.3)

*Desc - this routine takes input as date or yyyymmdd and returns the last date of the month it also return if the date is already a month end date
* Parameter Desc:
* PROCESS.DATE - Incoming/Outgoing - The Incoming date which needs to be processed, Output also return in the same variable
* MONTH.END - Outgoing - Its a flag to decide wheather the incoming date is month end or not. if it is a month.end it returns 'YES'
* RESV.1,RESV.2,RESV.3 - Reserverd - reserved for future use
#20958

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

  • realfunny
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 29
  • Thank you received: 0

realfunny replied the topic: RTN LAST.DAY.OF.THIS.MONTH

Thank you very much, i will try to do it.
#20960

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

  • Posts: 44
  • Karma: -1
  • Thank you received: 0

baskarjay replied the topic: RTN LAST.DAY.OF.THIS.MONTH

HI MADHULATHA,

This routine gives wrong output ....

Pls dont suggest this ....
#21912

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

  • VK
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • R13|TAFC|jBASE|windoze
  • Posts: 609
  • Thank you received: 88

VK replied the topic: RTN LAST.DAY.OF.THIS.MONTH

Hi
Why do you need a routine? Just add 1 day to the current date and see if the day number in result is 1...

For a reverse operation, subtract 1 day from the first day of next month and there you are :))

Cheers
VK
#21913
The following user(s) said Thank You: baskarjay

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

  • Posts: 1
  • Thank you received: 0

purangika replied the topic: RTN LAST.DAY.OF.THIS.MONTH

The last day of current month can be taken as said but it has to have a additional condition when it is in 12th month. 1 day subtract should happen from the next year january first.
#21952

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

  • VK
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • R13|TAFC|jBASE|windoze
  • Posts: 609
  • Thank you received: 88

VK replied the topic: RTN LAST.DAY.OF.THIS.MONTH

Hi
I wasn't fully clear in my proposition... All adds / subtracts have to be applied to the internal date that is obtained using ICONV(date, 'D').

Cheers
VK
#21956
The following user(s) said Thank You: baskarjay

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

  • Posts: 44
  • Karma: -1
  • Thank you received: 0

baskarjay replied the topic: RTN LAST.DAY.OF.THIS.MONTH

Thanks VK for your response ...
I got the solution .....
#21968

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

  • Posts: 9
  • Thank you received: 0

drjekoyemi replied the topic: RTN LAST.DAY.OF.THIS.MONTH

Hi BASKARJAY

Kindly share the solution you finally settled for

Thanks
#22032

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

  • VK
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • R13|TAFC|jBASE|windoze
  • Posts: 609
  • Thank you received: 88

VK replied the topic: RTN LAST.DAY.OF.THIS.MONTH

Hi
it's very easy to do if you know jBC a little bit :))

1. Calculate the number of next month; if it's January - add 1 to the year as well.
2. Construct the date for the 1st day of next month, ICONV it to the internal representation.
3. Subtract one from that and OCONV it back.

That if we're talking about calendar days. Use CDT if it's working days.
Of course CDT can be used in both cases but I prefer a solution that is more "native" to DBMS.

Cheers
VK
#22043

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

Time to create page: 0.404 seconds