I have tried to follow this formula and it is bugging the heck out of me because i cant do it.

It may not even be working like I was told it was supposed to do.

This formula is supposed to return the date in a format like day of the year and 2 digit year, today would be 28311.

Here it is:

< ="Content-" content="text/; charset=utf-8">< name="ProgId" content="Word.">< name="Generator" content="Microsoft Word 14">< name="Originator" content="Microsoft Word 14"><>

ToNumber (Mid(ToText(DatePart("y",{to2Tran.TranDate}) & DatePart("yyyy",{to2Tran.TranDate})),4,2))

I get the "y" would pull 283 and "yyyy" pulls 2011.  It is the totext with ,4,2 that I do not understand.

How does this formula pull the right information?
I just don't see it.

That is what I thought.  So I am not crazy after all.

I did something similar to what you said:

Julian day then 1 digit year

(totext(DatePart("y",{to2tran.tranDate}),0)) & (mid(totext(DatePart("yyyy",{to2tran.tranDate}),0),4,1))


1 digit Julian year then date

(mid(totext(DatePart("yyyy",{to2tran.tranDate}),0),4,1)) & (totext(DatePart("y",{to2tran.tranDate}),0))

I can modify the year section for a 1 digit or 2 digit year.

That worked like a charm too.

Thanks for your help.