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 can fornce Datevalue() to return only date. Thank you very much.
try to wrap with FORMAT,
= FORMAT(DATEVALUE(), "YYYY/MM/DD")
2 Replies
lastnn30 Try:
Column = VAR __Space = SEARCH(" ",[DateTime]) VAR __Date = LEFT([DateTime],__Space) VAR __Result = DATEVALUE(__Date) RETURN __Resulttry to wrap with FORMAT,
= FORMAT(DATEVALUE(), "YYYY/MM/DD")
