I have a data object which is type Character at Universe level (Mydate) using SQL Server. As mentioned Mydate is format Character and its output is yyyy.dd.mm.
How do convert this to a date format so its works at report level when used in a prompt
See attached, where I believe I am need to amend
Many thanks for any help