Wow, Paul. I kept that in my notes just in case I ever run into it!
Karen
> After some Google searching I found that Excel uses an "odd" 5 digit
> Julian
> day/date storing method. The number, in this case 39833, is the number of
> days since 12/30/1899. Once I knew this I was able to import the "date"
> column into an integer column in Rbase and add a computed column,
> (addday('12/30/1899', integer value)). In my example it converts
> (addday('12/30/1899', 39833)) to 1/20/2009.
>
> Thank you John and thank you all. I hope someone else can learn from my
> morning and not have to re-do this down the road.
>
> Paul Buckley
