I am trying to convert the DOB field from PER in a report to show only the date, but I do not succeed using this: “cast(patientper.dob as DATE) as geboorte”. This shows the date as well as the time.
I have tried a lot, but nothing seems to work.
What command/format can I use in the source editor? Or is there a way to do the formatting in report design?