Determine date given Day of year and year. (1 Viewer)

[pickslides]

I have fields [DayOfYear] and [Year] can I somehow produce the dd/mm/yyyy from this. I know how to do it in Excel but the Asscess function Date() is a little different.

I.e. if [DayOfYear] =152, [Year] = 2014 then [Date] = 2/6/2014

MQ

 

[vbaInet]

Sure thing. You can use the DateSerial() function or a combination of the Month() and DateValue() function.

http://www.techonthenet.com/access/functions/date/dateserial.php

 

[GinaWhipp]

Hmm, we just a thread that had an issue related to using Reserved Words and Year is a Reserved Word. (http://www.access-programmers.co.uk/forums/showthread.php?p=1361060#post1361060) You'll be wanting to change that before you end up in the same boat. And, you'll want to make sure you're not using anymore of those, here's a complete list...

http://allenbrowne.com/AppIssueBadWord.html

 

[Galaxiom]

DateAdd("d", [DayOfYear], DateSerial([yearfield],1,0))

 

[Brianwarnock]

Why two function calls won't

Dateserial([yearfield],1,[dayofyear])

Do the trick?

Sorry can't test haven't got Access any more

Brian

 

[namliam]

Brian is right,
?dateserial(2014,1,152)
01-JUN-2014
or
?dateserial(2014,1,0) + 152
01-JUN-2014

 

[Brianwarnock]

Thanks for that Namliam

Brian