How do I get good dates

florent.martini

Hi,

Here is my code :

Revenue_yoy, err = ek.get_data(flat_list_PG, ["TR.RevenueMean","TR.RevenueMean.Date"],{'Frq':'FY','Period':'FY1','SDate':'-1','EDate':'3'})
Revenue_yoy = Revenue_yoy.iloc[::-1]
Revenue_qoq, err = ek.get_data(flat_list_PG, ["TR.RevenueMean","TR.RevenueMean.Date"],{'Frq':'FQ','Period':'FQ1','SDate':'-1','EDate':'8'})
Revenue_qoq = Revenue_qoq.iloc[::-1]
Revenue_yoy

As you can see thereafter :

The dates are not right.

For the Dataframe Revenue_qoq it is the same.

Thanks for your help

chavalit-jintamalit

Hi @florent.martini

You can use "TR.RevenueMean.periodenddate" field.