Forum Discussion
kafreitass
Helper I
3 years agoCompare 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?
- 3 years ago
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.
aj1973
Community Champion
3 years agoHi 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.
kafreitass
Helper I
3 years agoaj1973 Thank you. It worked perfectly.