How to replace a value in a date column?

Question

There is a data entry error in a date field that I'm trying to replace using the "Replace Values" in the query editor. &nbsp;I want to replace "5/8/2016" with "5/7/2016". &nbsp;however, when try to do this using the "Replace Value" function, it doesn't change. &nbsp;Is their a formatting issue that needs to be done first?

marcelbeug · Accepted Answer

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"):

Forum Discussion

How to replace a value in a date column?

2 Replies

Related content

how to dynamically replace values for multiple columns

Replace all values with 0 in column

Replace null values of one column to another column.

Replacing values with Iterations

Replace value based on condition from other column