What if I'm using a function that expects a date value, and I'm passing it 'date'?

Responsive Ad Header

Question

Grade: Education Subject: Support
What if I'm using a function that expects a date value, and I'm passing it 'date'?
Asked by:
82 Viewed 82 Answers
Responsive Ad After Question

Answer (82)

Best Answer
(302)
Ensure that the 'date' variable or column actually contains a valid date value. Sometimes, data imported from external sources might be formatted as text. You may need to use a function like `DateValue()` or `DateTimeValue()` to convert the text to a proper date format before using it in the function.