Date Expression 1

[ocan]

On a form, in 1 text box, how could I type in:

julian date-----(three digit day)(last 2 digits of the year) and in another text box return the date.

ie. type in 00104 & have it return 1/1/04.

Thanks.

 

[TheAceMan1]

How are ya ocan . . . . .

See:

http://support.microsoft.com/default.aspx?scid=kb;en-us;162745

See Ya! . . . . . .

 

[PHV]

Something like this ?
AnotherTextBox = DateSerial(Right(JulianDate, 2), 1, Left(JulianDate, 3))

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[ocan]

That works perfect!