maimiek said:
Extracting the julian Mont/Day from a barcode. I want to know how to turn
that into the mm/dd format on the form.
By "julian", I take it you mean the day of the year, and you want to convert
that to a month/day-of-month format.
You can't actually do that accurately without knowing what year is
referenced, since some years are leap years and some are not. If the
current year is implied, you can use an expression like this:
=DateAdd("d", [YourJulianDayField], DateSerial(Year(Date()), 1, 0))
If the current year is *not* implied, but you have a control that holds the
year, you can reference that control in the expression:
=DateAdd("d", [YourJulianDayField], DateSerial(Year([YourYearField]), 1,
0))
