Forum Discussion

PatrickByGecko's avatar
PatrickByGecko
Helper V
6 years ago
Solved

Probleme when Evaluating dates

Hello I get a problem when comparing to dates, Is this instruction correct?   VAR _DateBeginMonth = DATEVALUE("01/" & MONTH(TODAY()) & "/" & YEAR(TODAY())) VAR _DateBeginFinal = if ( 'TABLE'[DA...
Need Help
  • PatrickByGecko's avatar
    PatrickByGecko
    6 years ago

    Hi

    I did put my conditions inside the FIlter command and it is OK. It is not a beautiful code but it works...

    Thank you again.

PatrickByGecko's avatar
PatrickByGecko
Helper V
6 years ago

 

I did this way

VAR _DateBeginMonth = DATE( YEAR(TODAY()); MONTH(TODAY()) ; 1)
But the comparison gives the same, is always false though I'm sure 'TABLE'[DATE BEGIN] is bigger.
PatrickByGecko's avatar
PatrickByGecko
Helper V
6 years ago

 

When I display the values so as to check

VAR _DateBeginMonth = 43922 and 'TABLE'[DATE BEGIN] = 43942. So the problem must coming from the syntax of comparison. I think..

 

  • mwegener's avatar
    mwegener
    Most Valuable Professional
    6 years ago

    Okay, these are the dates you are comparing