i've got a issue with a date field that i want to insert into a qvd file.
In the attached file there is the date field. When i do the store in a qvd some of the date are set as text and other times as date. Even if i put the
date(@7,'DD/MM/YYYY') AS #@7
it does'nt work...
For example the date '14/07/2018' can't be found if i force the date() formula.
Try it with: date(date#(@7,'DD/MM/YYYY'), 'DD/MM/YYYY') AS #@7
View solution in original post
Date(Num#(@7),'DD/MM/YYYY') as #@7