Forum Discussion

lastnn30's avatar
lastnn30
Post Patron
3 years ago
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...
Need Help
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    try to wrap with FORMAT,

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

Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago

lastnn30 Try:

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