Forum Discussion

jcountryman's avatar
jcountryman
Icon for Helper I rankHelper I
6 years ago
Solved

Value for indefinite future/past dates?

Sorry in advance if this is poorly worded:   Is there a value that can be used as a placeholder for indefinite dates? For example, something like [DATE]>FARFUTURE() that will _always_ be false regar...
  • jcountryman's avatar
    jcountryman
    6 years ago

    I don't know what's so hard about saying it, but there's no such thing as an indefinite date value in DAX. Anonymous 's condensending reframing of the problem notwithstanding.

     

    FWIW, it's DATE(9999,12,31). ("Google it." Whatever, man.)

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Sure, you can use a value for this purpose. Just take the highest possible value of the datetime data type (google for it).