Find day number from date

Answers

• Kowa Member Posts: 926

  2006-11-02

  Basically

  NoOfDay :=  MyDate - 311206D + 365;
  

  
  If you need the end of the fiscal year instead, Function FindEndOfFiscalYear in Codeunit 8 AccSchedManagement will provide this.
  

  CALCDATE('<CY>',TODAY)
  

  will return the last day of the year.

  Kai Kowalewski

  0
• erugalatha Member Posts: 120

  2006-11-02

  Thanks a lot ... works great!

  0
• Kowa Member Posts: 926

  2006-11-02

  But don't forget that a leap year has 366 days
  You can evaluate this with :
  

  Year := DATE2DMY(Date, 3) + 2000; 
  IsLeapYear := (Year MOD 4 = 0) AND ((Year MOD 100 <> 0) OR (Year MOD 400 = 0));
  

  Kai Kowalewski

  0
• SteveO Member Posts: 164

  2006-11-17

  Alternatively:
  

  // Calculates the Number of Days that have occured since the start of the year
  NumDays := MyDate - CALCDATE('-CY', TODAY) + 1;
  

  
  
  Don't have to worry about leap years.

  This isn't a signature, I type this at the bottom of every message

  0