EViews.com

Is it possible to change the date representation (say from month/day/year to day/month/year) found in general options in an EViews program? I have a VBA program that is pushing some dates to EViews to set the smpl for the workfile. It works fine if the General Options -> Date Representation is set the same as my Excel but not if it isn't.

Thanks

Not quite.

Option 1) Use YYYY/MM/DD format in your VBA code.

Option 2) Use optset to temporarily override the global settings to one of your choice.

Thanks Gareth, appreciate it