unable to store date in QVD

[#1]

Hi

I am trying to do IncrementalLoad and want to store my MaxDate into a QVD file.

My orginial QVD with all the data has a field called CreateDate

CreateDate is like 2014-05-22 10:00:00

When i want to store this

I select Max(CreateDate) as CreateDate into a QVD

But when i load my QVD it is empty.

Like it doesnt know the format or something=?

[#2]

I have an extra question.

Actually my original date field is YYYY-MM-DD hh:mm:ss[.fff] but when i try to convert it like this i dont get the miliseconds. How come i loose my miliseconds?

I do like this:

Date#(Date(CreateDate,'YYYY-MM-DD hh:mm:ss[.fff]')) as CreateDate

[tresesco]

Date#() and Date() are misplaced. Try like:

Date(Date#(CreateDate,'YYYY-MM-DD hh:mm:ss[.fff]')) as CreateDate

[#4]

Then my createdate is empty

[tresesco]

Make sure that your field name and format are so. Issue would possibly be a silly mistake.

[#6]

they are exactly the same. 😕

[tresesco]

Try to share the sample qvd/qvw