Skip to main content
Topics#Tableau Desktop & Web AuthoringQuestion de guruprasad p
guruprasad p a posé une question dans #Tableau Desktop & Web Authoring
20 juin 2025, 05:38

I am using datediff function and my question is mgmnt cutoff is '0' i need to return all values.

DATEDIFF('day',DATE([RunDate]),[RunDate Parameter]) < [Management Cutoff day ]

and

DATEDIFF('day',DATE([RunDate]),[RunDate Parameter])>=0

 

Glimpse:

Rundate parameter is user selection date

Management cutoff days it's a parameter Integer type (0,10,30,60)

 

when i select mgmnt cutoff day from list 0 it should return all value.

 

How to do that please suggest i am seeing blank worksheet.I am using datediff function and my question is mgmnt cutoff is '0' i need to return all values.

15 réponses
  1. guruprasad p
    20 juin 2025, 10:50

    Thanks @Jim Dehner​ also i want to add this query into custom sql level Tableau.

    Can you help me with modify syntax. i am getting incorrect syntax connection are valid. Thanks @Jim Dehner​ also i want to add this query into custom sql level Tableau. Can you help me with modify syntax. i am getting incorrect syntax connection are valid. CASE WHEN <Parameters.CASE 

    WHEN <Parameters.Management Cutoff day > = 0 THEN

    DATEDIFF(day,([RunDate]),<Parameters.RunDate Parameter>)=0

     

    ELSE

     

    DATEDIFF(day,([RunDate]),<Parameters.RunDate Parameter>) < <Parameters.Management Cutoff day >

    AND

    DATEDIFF(day,([RunDate]),<Parameters.RunDate Parameter>)>=0

     

    END

Rédiger une réponse...
0/9000