Date Number - Relation with other languages

[sschaffrath]

Hi,

Does anybody know how the date number works in EViews?

I´m in need of using the number instead of the date string, and I´m finding hard to understand the relation it has with the Excel date number.
I could eventually use a command like @dateval, but I´d like to know how it works before...

I´d be grateful if someone could give me a hint.

Thks!

Sven

[EViews Chris]

The EViews date number is days since 1 Jan 1AD *if* the current calendar had existed back in 1AD (which it didn't).

This is a straight offset from the Excel date number (which is based on some slightly odd base date like 30th Dec 1899 -- check the Excel docs for that one) except that Excel has some weird issues with Feb 29 1900.

The bottom line is that unless you're dealing with dates around 1900, you can probably just add an offset to convert into EViews from Excel and subtract an offset to convert out of EViews into Excel.

Chris

[sschaffrath]

Chris,

Thanks for that! I`ll check.

Sven