how can I change the date value of a field in my QVD historical file?
I found some anomalies in my data that we're working to resolve, but I don't want to load all the previous tables I have (they are month end tables, and these anomalies occurred awhile ago) and I would like to change their value. Some analysts at my company entered: MM/DD/2106 for the date they were supposed to enter instead of 2016.
Here's what I tried, and it's not working.... any suggestions?
if(Pkey = 33479, [Response Due Date] = date(date#(06/04/2016, 'MM/DD/YYYY')), [Response Due Date])
I also tried:
if(Pkey = 33479, left(date([Response Due Date],'MM/DD/YYYY'),6)&year(today()),[Response Due Date])
The date is not changing though. It's still 06/04/2106 when I view in a table box.