Julian Date conversion

[Kerry Michael]

Hi Everybody!

I m trying to calculate interest and discounts.

I have a Julian date of (lets say today) (13111)E12345 in a loan receipt number for accounts in my A/R.

How do I convert the Julian date into a normal date? I only want to use the 13111 and exclude any integers after that.

Thanks!

 

[Kerry Michael]

Wow. Works perfectly. Thank you very much!!