Occasionally, you need to retrieve date fields that don’t look like dates. The most common example in CPS is the clinicaldate field in the document table. There are formulae for converting between these IDs and their corresponding dates. Here is an example query that shows how to retrieve the clinicaldate as a real date as […]