The elusive @datediff

For questions regarding the import, export and manipulation of data in EViews, including graphing and basic statistics.

Moderators: EViews Gareth, EViews Steve, EViews Moderator, EViews Jason

Chthoniid
Posts: 24
Joined: Mon Oct 22, 2012 6:02 pm

The elusive @datediff

Postby Chthoniid » Sun Aug 24, 2014 1:21 am

Ok

Once again something basic seems to be eluding me. I have a data-set of 1300 elephant tusks, and know the date each was used up as a carving.
The date format is dd/mm/yy

I'm trying to work out the days from when it was released to the legal carving factories (ie. how long a tusk lasts before it is depleted).
I've tried the function @datediff(date1, date2, format)

Can't figure out how to convert a date as dd/mm/yy format into a number like 730088.0. I'm sure it's pretty basic, but my searching of the guides hasn't helped.

I'm using Eviews 7 still

Cheers, B

Chthoniid
Posts: 24
Joined: Mon Oct 22, 2012 6:02 pm

Re: The elusive @datediff

Postby Chthoniid » Sun Aug 24, 2014 1:42 am

Ok, that's the first basic problem solved.

Change the value display from days.

Now just to work out how to find the numeric value of specific dates.

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13604
Joined: Tue Sep 16, 2008 5:38 pm

Re: The elusive @datediff

Postby EViews Gareth » Sun Aug 24, 2014 8:44 am

@dateval


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 2 guests