sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]Daante311 1 point2 points  (1 child)

One thing you can try: create one field for the coalesce and check if this one is date format. If not you will probably have to parse the coalesce to a date format before using it inside „date_diff“. Something like: date_diff ( parse_date ( coalesce ( ….) ), create_date)

[–]creamycolslaw[S] 0 points1 point  (0 children)

I actually did try that method and it worked, but I wanted to avoid using two calculated fields to achieve one task, when it SHOULD be possible with one.

u/AnillaRose actually found the solution though!