Date conversion within unstructured workfiles

[adrian_d]

Hello,
I have an unstructured/undated workfile and there I have a series containing intraday date (not unique, there are rows with the same date). How can I create from this a series containg daily, not intraday, date? I tried things such as using series daily_date = @makedate(intraday_date, "ddmmyyyy") but it doesn't work. Please help! :-)

adrian

[EViews Gareth]

Post your workfile.

[adrian_d]

Post your workfile.

Ok, take a look please. The aim is to have daily data with sum of total_conversions series per day.

[EViews Gareth]

Something like:

Code: Select all

series date = @datefloor(activity_date_time, "DD") pagecreate(page=daily) d7 2014/01/01 2014/02/28 series date = @date copy(c=s) p2c\total_conversions daily\* @src date @dest date

[adrian_d]

Great idea with @datefloor, thank you! :)