Converting Julian Date

[iuphim]

Hi I have this formula in Excel to convert to Julian but I what I need is a way to convert in Access. Do you know how to convert?


Excel formula:
=("1/1/"&MID(A1,2,2))+MID(A1,4,3)-1

Thanks,

 

[MSAccessRookie]

Hi I have this formula in Excel to convert to Julian but I what I need is a way to convert in Access. Do you know how to convert?


Excel formula:
=("1/1/"&MID(A1,2,2))+MID(A1,4,3)-1

Thanks,

Check out the link below and see if it helps.

http://support.microsoft.com/kb/209922

 

[iuphim]

I found this

NormalDate: CDate(Format(((DateValue("01/01/"+LTrim(Str(1900+Int([Your Field
Name]/1000))))+[Your Field Name]-Int([Your Field
Name]/1000)*1000))-1,"mm-dd-yy"))

Can someone help me add in and iff statement before this for null value?

I tried the formula below but kept getting an invalid argument error. If I removed the iif statement then it would run fine.

NormalDate: iif([your field value]<>"0",CDate(Format(((DateValue("01/01/"+LTrim(Str(1900+Int([Your Field
Name]/1000))))+[Your Field Name]-Int([Your Field
Name]/1000)*1000))-1,"mm-dd-yy")),0)


And how do I get the previous of the current max[your field name] or restrict that so if the max[your field name] not between 1/1/2009 and 1/31/2009 then the max of the [your field name] is what I want. Thanks.

 

[iuphim]

Check out the link below and see if it helps.

http://support.microsoft.com/kb/209922

Thanks, but I was lost.