Datevalue() function to return only date without time

[lastnn30]

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.

[FreemanZ · Accepted solution]

try to wrap with FORMAT,

= FORMAT(DATEVALUE(), "YYYY/MM/DD")

[Greg_Deckler]

@lastnn30 Try:

Column = 
  VAR __Space = SEARCH(" ",[DateTime])
  VAR __Date = LEFT([DateTime],__Space)
  VAR __Result = DATEVALUE(__Date)
RETURN
  __Result