This works as designed i.e., the Person User Data (Personnel) view in Insight returns data in text format for values populated for UDF Data Labels even if the Data Type for a label is set to Date in UDF configuration.
As a workaround, you can use the below calculation which will return the same values but in date format in the calculation's column. You will be then able to create a date filter for that column (Today, Last 30 Days and etc.).
TO_DATE( PRCI_PERSON_USER_DATA.TEXT2, 'DD-MON-RRRR')
or
TO_DATE( PRCI_PERSON_USER_DATA.TEXT2, 'DD-MM-RRRR')
Dates in UDF reports
Though UDFs are set up in date format Insight reports return data in text format so we cannot use date filters such as Today, Last 30 Days and etc.
J
Written by Joshua Shooter
Updated over a month ago