date function 1

[durug]

Hi everybody!

Does anybody know a function that return the date giving the number of the day in the current year.
like: 45 = february 14

thanks a lot
durug

 

[GaryC123]

Could do somthing like this...

No_Days=DateDiff("d",cdate("1/1/" & year(Now)), Now) Saturday 12.00

20.00

3.00am

Sunday [img http

 

[durug]

Thanks, but the problem is a little different: I need the opossite direction:
i have the number of the day in year and I need the function to return the day and month.

like the reverse of the datepart function or GaryC123 function.

I have the number 14 all I need to return is January, 14

thanks again

 

[GaryC123]

strdate=(cdate("1/1/" & year(Now)) + 45)-1 Saturday 12.00

20.00

3.00am

Sunday [img http

 

[durug]

if I could I would give you 2 starts, not one
thanks a lot