I was updating the END_DT on BO_REL table to inactivate invalid relationships.
This is on MS SQL server database.
I used END_DT=GETDATE() in the update statement, but the results were not correct. Those contacts were still appearing on the front end pages for company and contact.
The problem is the "time part" in the end date field.
So the correct way to update it is by using:
END_DT=CONVERT(DATETIME,CONVERT(VARCHAR(10),GETDATE(),101),101)
No comments:
Post a Comment