Creating reports and dashboards | Stimulsoft community forum

Hi, how to convert day of year to date? thx

Hello,

You can use the following expression:
{DateSerial(2023,1,1).AddDays(dayOfYear - 1)}

Thank you.

Hi Lech Kulikowski, it worked, however, I have a new challenge.

Suppose that the year is a string (that was taken using Substring function), and has 2 digits, it means, the Substring returns 23. I am supposing that the year must be decimal and 4 digits, and as it is returning string, I need to convert it in decimal. I tried to use (decimal) before the Substring, but it didn't work, because I was concatenated 20+(decimal) Substring(xx,4,2).
A new question, will this function support leap year?
thx

Hello,

You can use the following expression:
{DateSerial(int.Parse(Substring(Variable1,2,2)),1,1).AddDays(dayOfYear - 1)}

Thank you.