date information from HRF-to-SIF

[River Huang]

Dear All, I'd like to have my date information below to be converted from HRF-to-SIF.

* Example generated by -dataex-. To install: ssc install dataex
clear
input str6 tradingmonth
"Feb-06"
"Feb-06"
"Feb-06"
"Feb-06"
"Mar-06"
"Mar-06"
"Mar-06"
"Mar-06"
"Apr-06"
"Apr-06"
"Apr-06"
"Apr-06"
"May-06"
"May-06"
end

Following the suggestion in this thread https://www.statalist.org/forums/for...ase-management, I did the following

gen mdate = mofd(daily(tradingmonth, "MY", 2050))
format mdate %tm

I got the right result, but wonder if this code is OK? Thanks for your suggestions.

[William Lisowski]

I would have gone directly from the HRF to a monthly date without first passing through a daily date.

gen mdate = monthly(tradingmonth, "MY", 2050)

[River Huang]

Thanks for the suggestion, William.