Date comparison with DateDiff

Currently the date comparison of two dates can only be done with one format “yyyy-MM-dd HH:mm:ss”, but to work with another one the DateDiff function does not work correctly. This is a problem because we use German format. It would be important for us if this case could be considered.

1 reply

    • samuel_alma
    • 7 days ago
    • Reported - view

    This is not correct. The text representation of a date is not how the datediff function operates. What matters is that its an actual date. Your first job, if you have your dates as text/string, is to convert them into actual date-time values. Look at the StringtoDateTime function. If you need to do this with Granular functions in custom columns, you cannot use this function, so it may be harder to do. But the principle still applies.

Content aside

  • Status Answered
  • 7 days agoLast active
  • 1Replies
  • 25Views
  • 2 Following