Forum Discussion

kafreitass's avatar
kafreitass
Helper I
3 years ago
Solved

Compare two dates from different tables

Hi Guys, 
Someone can help me?
I have two tables and I would like to know if the Date of Table A is greater than the date of Table B. How could I make this comparison?

  • Hi kafreitass 

    the 2 dates columns need to be in the same visual(Table) aren't they? if so then you can use DATEDIFF function to determine if the is negative or positive and know which one is greater.

2 Replies

  • aj1973's avatar
    aj1973
    Community Champion

    Hi kafreitass 

    the 2 dates columns need to be in the same visual(Table) aren't they? if so then you can use DATEDIFF function to determine if the is negative or positive and know which one is greater.