Using dates in table calculations (3.30+)

Looker Q&A Looker
21

There is a lot of really useful information here - thank you!

Does anyone have a solution for comparing a DUE date with an ACTUAL date so when a task was DUE to when it ACTUALLY happened.. if I’ve recorded both dates, how can I report on how many times the task was actually completed on time?

Any help gratefully received :0)

22

We have date fields stored as strings. Is there any support for date parsing?

​​​​​​​ - looker n00b

UPDATE: looks like there’s a to_date() function for this.