Date control

• change the string to date

  dateparse(’ddMMMMyyyy’, ‘15April2022’)

• extract the part of date (e.g. only year/ month)

  datepart()

• difference between date

  DATEDIFF(‘day’, [Order Date], [Ship Date])