Compute the difference between two dates

Posted by

You have firstĀ  to convert the two dates to be compared to the julian format.

    
11.19 FIELD.NAME..... LAST.TRADE
12.19. 1 OPERATION... IDESC LAST.TRADE
14.19 LENGTH.MASK.... 12L
15.19. 1 CONVERSION.. JULIAN

11.20 FIELD.NAME..... COMPANY
12.20. 1 OPERATION... PORTFOLIO
14.20 LENGTH.MASK.... 18L
15.20. 1 CONVERSION.. L SEC.ACC.MASTER,CO.CODE
32.20 SINGLE.MULTI... S

11.21 FIELD.NAME..... TODAY
12.21. 1 OPERATION... F COMPANY
15.21. 1 CONVERSION.. L DATES,TODAY
15.21. 2 CONVERSION.. JULIAN

11.22 FIELD.NAME..... DAYS.TO.MAT
12.22. 1 OPERATION... C LAST.TRADE - TODAY
13.22 COLUMN......... 7
19.22. 1 GB FIELD.LBL Days to Mat.
32.22 SINGLE.MULTI... S

 

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.