Hello, using Eikon API in Python, trying to pull data on WACC, and the date is output as datetime (eg, 2019-04-30T00:00:00Z). Is it possible to output it only as a date? I am sure I could change it with Pandas, but Pandas didn't seem to recognise it as datetime -- any idea why that may be? thank you for your help
#import refinitiv.data as rd #rd.open_session() import eikon as rd rd.set_app_key('8_______1') startdate = "2019-01-01" enddate = "2022-07-14" syntax = "SCREEN(U(IN(Equity(active,public,primary)))," \ "IN(TR.HQCountryCode,AT;BE;BM;CA;CH;KY;DE;DK;ES;FI;FR;FO;GB;GG;GI;GR;GL;IM;IE;IS;IT;JE;LI;LU;MC;NL;NO;PR;PT;SE;US;VG)," \ "IN(TR.TRBCEconSectorCode,52,53,4,57),CURN=USD)" WACCfields = ['TR.WACC.date', 'TR.WACC'] df3, err = rd.get_data(syntax, WACCfields, {'SDate': startdate,'EDate': enddate, 'FRQ': 'M'}, )