From CSV to qvd

[Carlaf_93]

Good afternoon,

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 

load

date(@7,'DD/MM/YYYY') AS #@7

it does'nt work...

Any ideas?

For example the date '14/07/2018' can't be found if i force the date() formula.

Thanks

C

[marcus_sommer · Accepted solution]

Try it with: date(date#(@7,'DD/MM/YYYY'), 'DD/MM/YYYY') AS #@7

[BrunPierre]

Like this.

Date(Num#(@7),'DD/MM/YYYY') as #@7