Recent content by drewship

Thanks. Someone else actually provided =Year([ReqDate]) Mod 10 & Format([ReqDate]-DateSerial(Year([ReqDate])-1,12,31),"000") which I placed in the control source of the text box and it works fine.

Hello all, I have played around with many variations and this what I have come up with so far. The below code as you can see is a function and I have it in a module called JulianDateConvert since I have not been able to combine it with the Sub (probably cant combine them). Public Function...