Download IBP KF data via CPI-DS

[willsuus]

I am using the calculation scenario to download IBP KF data (consensus fcst) to a .csv file. I have included TSTFR and TSTTO in my output file but they both show up with question marks where the day should be (i.e. 2023.??.01). Any idea what is causing this and how it can be resolved.

[riyazahmed_ca2 · Accepted solution]

Hi Susan,

I don't think of any direct cause of it. May be you can try using the manual date type conversion method like below to resolve this.

To_Date(To_Char(**your date field**, 'YYYY.MM.DD'), 'YYYY.MM.DD')

Best Regards,

Riyaz

[willsuus · Accepted solution]

This worked, thank you.

Do you know a way to remove the timestamp portion that is returned along with the date?

2023.01.01 00:00:00

[riyazahmed_ca2 · Accepted solution]

Hi Susan,

Try changing the data type from Date Time to Date. If it is not applicable in CI-DS, then suggest to change it to Text using To_Char function.

Best Regards,

Riyaz

[willsuus · Accepted solution]

By changing the datestore field to Varchar and only using the To_Char portion of the formula, I was able to have just the date portion in the file.

Thank you, again, for your help.