I would like to display the fields AFKO.GSTRI and AFKO.GETRI as timestamps to be able to use the KPI "Days_Between". But I always get an error message however the fields AFKO.GSTRS and AFKO.GLTRS are displayed properly without any problems.

Hi @anne.würz ,

Normally the days_between() function has as input two dates, upon my knowledge AFKO.GSTRI and AFKO.GETRI  are already dates. Which result do you have when applying directly days_between(AFKO.GSTRI ,AFKO.GETRI).?

Hi @javier.donos ,

this was also my first assumption. So, I already tried this and get the following error message - see screenshot.

Due to this error message, I started to try "On_Timestamp" to convert from a string to a date.

somehow it looks like the date columns have been converted to string, have you tried to see the table configuration in the Data extraction job, there is possible to see the current configuration of the table under "column configuration"

can you check the data type during the extraction? Go to the selected AFKO table and look at the data type from GSTRI and GETRI. It can be that it has been extracted as string.

If you uploaded directly via flat file, you can open any transformation and run the following query

SELECT * FROM INFORMATION_SCHEMA.COLUMNS

WHERE TABLE_NAME = 'AFKO';

This should show you the data type from all columns from AFKO