Get the Number of the day eg 150

TESDeveloper

Hi,

How in Business Central code can I get the current day in it's number equivalent. So for example 1st February is the 32nd out of 365.

Thank you.

Phogue

var
  CurrentDate: Date;
  EarlierDate: Date;
begin
  CurrentDate := Today(); //12th of June, 2020
  EarlierDate := DMY2Date(1, 1, 2020); //January 1st, 2020
  Message(StrSubstNo('Date 1: %1 - Date 2: %2 - Subtracted: %3', CurrentDate, EarlierDate, CurrentDate - EarlierDate+1));
  //Message = "Date 1: 12-06-20 - Date 2: 01-01-20 - Subtracted: 164"

You can just subtract a Date with January 1st of the relevant year from the date you're trying to find the number of.
If you compare with January 1st, you have to add 1 to the result, since it doesn't also count the day of January 1st. Or you can set the "EarlierDate" to 31st of December to the prior year.

Phogue

var
  CurrentDate: Date;
  EarlierDate: Date;
begin
  CurrentDate := Today(); //12th of June, 2020
  EarlierDate := DMY2Date(1, 1, 2020); //January 1st, 2020
  Message(StrSubstNo('Date 1: %1 - Date 2: %2 - Subtracted: %3', CurrentDate, EarlierDate, CurrentDate - EarlierDate+1));
  //Message = "Date 1: 12-06-20 - Date 2: 01-01-20 - Subtracted: 164"

You can just subtract a Date with January 1st of the relevant year from the date you're trying to find the number of.
If you compare with January 1st, you have to add 1 to the result, since it doesn't also count the day of January 1st. Or you can set the "EarlierDate" to 31st of December to the prior year.

DenSter

Doesn't the virtual Date table have day/week numbers?

DenSter

Never mind, I thought the "Period No" was the day in the year but it looks like it is the day of the week.

vuasoikeo

kk