Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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=?
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
Date#() and Date() are misplaced. Try like:
Date(Date#(CreateDate,'YYYY-MM-DD hh:mm:ss[.fff]')) as CreateDate
Then my createdate is empty
Make sure that your field name and format are so. Issue would possibly be a silly mistake.
they are exactly the same. 😕
Try to share the sample qvd/qvw