Forum Discussion
kafreitass
3 years agoHelper I
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
- aj1973Community 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.
- kafreitassHelper I
aj1973 Thank you. It worked perfectly.