Hi Ajith,
That behavior is a bit curious. It looks like it is assuming the one quote is the beginning of the string you are going to set doAdmn to. It seems if you are setting a column to a string in queryview, the last quote is not needed.
If you query the table after the request, you’ll see it is not setting the value properly.
If you want to set the field to a variable date you could use the following:
QueryDo(‘update dengueMaha where dateAdmn = “1.8.13 P” set doAdmn = ‘ $ Display(Date(day:1, month:8, year: 2013)))
If you are just setting to a date constant you can do:
update dengueMaha where dateAdmn = “1.8.13 P” set doAdmn = #20130801