'Check date with Soda-Spark

I am trying to test data using soda-spark. I am trying to test whether the format of a date is valid or not. Now I am stuck in defining the test.

This is what I have at the moment:

scan definition = ("""
table_name: demo
metrics: 
 -row_count
columns:
 date: 
  Valid_format: ??????
  tests:
  - invalid_percentage == 0
  """)

Can anyone help me what to fill in on the '??????' to check if it is a valid Date. what it should be is 'dd/mm/yyyy hh:mm

thanks in advance!



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source