Forum Discussion
Solved
Datevalue() function to return only date without time
Hi I have a column in a table which has dates formatted as text (moved to the left hand side). I used Datevalue to convert them to dates. It did work but each date has time as well. I wonder if I ca...
try to wrap with FORMAT,
= FORMAT(DATEVALUE(), "YYYY/MM/DD")
try to wrap with FORMAT,
= FORMAT(DATEVALUE(), "YYYY/MM/DD")