Skip to main content
Topics#Tableau Desktop & Web AuthoringTableau Community Forums Member (Inactive)'s Question
Tableau Community Forums Member (Inactive) (Salesforce) asked in #Tableau Desktop & Web Authoring
Jun 3, 2025, 5:37 PM

I'm trying to get the following formula to spit out a "Met" instead of Null, but I get the folloiwng error and not sure how to get around it. Expected type datetime, found string. Result type from "IF" expressions must match.

IF (dateadd('day',[Measure Met],dateadd('week',Sum([Solve for X]),today()))) >= TODAY()THEN dateadd('day',[Measure Met],dateadd('week',Sum([Solve for X]),today())) ELSE NULL end

5 answers
  1. Hideaki Shiihara (Tableau Ambassador (KYOCERA Communication Systems Co., Ltd.))
    Jun 4, 2025, 9:42 AM

    Hi, @Jeff Haney​ 

    What happens if you use the STR function to convert the date result when it is True into text?

    It will look like the image below. Give it a try.

    (Since characters cannot be mixed in the date field, it may be a good idea to stick to characters.)​

     

    <sample>​

    Hi, @Jeff Haney​ What happens if you use the STR function to convert the date result when it is True into text? It will look like the image below. Give it a try. 

    <calc sample>

    IF (dateadd('day',[Measure Met],dateadd('week',Sum([Solve for X]),today()))) >= TODAY()THEN STR(dateadd('day',[Measure Met],dateadd('week',Sum([Solve for X]),today()))) ELSE 'Met' end

     

    ​

    ​

    *If you get the best results from this exchange, I would appreciate it if you could choose the best answer or upvote.

Write an answer...
0/9000