How to get the date

[J_L]

Hi all,

How can i convert the string to a date?

Eg:

001 => 1 Jan
.
.
.
032 => 1 Feb
.
.
.
365 => 31 Dec

Thanx in advance..

[XLGibbs]

use the Format function and date function..

Format(DateSerial(year(now(),1,1) + [your field with day number] - 1,"d mmm")

Or this one:

DateAdd(d,[your day number]-1,#1/1/2006#) if the year won't change.

There are lots of date functions, you just to have use your day field as the "Day" part of the expression, then format as "d mmm" to get the requested output.

Hope that helps.

[J_L]

thanks.. it works..

[Bob Phillips]

You can even take advantage of the peculiar date processing of office, that can calculate the nth day of a month, even where n > 31


format(dateserial(Year(Date),1,[your field with day number] ),"dd mmm yyyy")