Forum Discussion

Rsanjuan's avatar
Rsanjuan
Advocate III
9 years ago
Solved

How to replace a value in a date column?

There is a data entry error in a date field that I'm trying to replace using the "Replace Values" in the query editor.  I want to replace "5/8/2016" with "5/7/2016".  however, when try to do this usi...
Need Help
  • MarcelBeug's avatar
    MarcelBeug
    9 years ago

    There should be no issue if the column is of type date. Notice that dates don't come with surrounding double quotes.

     

    This is how it looks like, including the generated code (note" I'm configured on culture "en-US"):

     

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
9 years ago

Hi Rsanjuan,

 

Could you please mark the proper answer if it's convenient for you? That will be a help to others.

 

Best Regards!
Dale