Convert a number into Date

[elbimbo]

Hello there,

Does anybody knows how can I convert this no. (254) into its equivalent Month and days. Its actually 254 days of the year 2001. I want to Know how can I know its August 10,2001. (08/10/2001). Automatically using codes.

Pls. help. its important.

[khalik_ash]

use DateAdd function

msgbox DateAdd(d, 254,'08/10/2001')

[elbimbo]

Hi,

What if I have no Idea that it is August 10. I just know that its 254 days of the year 2001. My calculation is wrong coz Feb is only 28 or 29 days. How about if its a leap year.

Pls reply.

[khalik_ash]

function takes care of leap year... but u should have a base date to add...

[BuggyProgrammer]

probably would be more like this:

msgbox DateAdd("d", 253,"01/01/2001") 'the beginning of the year + 253 days (accounts for the first day of the year)

[elbimbo]

Welllll....

Your solution returns a one month advance.

[lazyjay]

Hi There,

Doing a little date math I found that
253
-31 for all of January
222
-28 for all of Feruary
194
-31 for all of March
163
-30 for all of April
133
-31 for all of May
102
-30 for all of June
72
-31 for all of July
41
-31 for all of August
10
= september 10

Or alternatively

MsgBox DateDiff("d", "12/31/2000", "8/10/2001")

Yeilds a result of 222

Hope this helps,

J