You can combine the three fields and convert it to a date field with a formula like:
Then if the dates you want to compare are are difference rows in the data source, there are a number of routes to produce the result you are looking for. It really depends on the question you want to answer, and at what level. Can you provide some example data that represents your situation, and what you want the results to be?
Thanks, Joe. You're a lifesaver. I had forgotten how to do this; getting senile. Works fine. The dates I'm comparing are in the same rows, so I'm using DATEDIFF to get the results I need.
Hi, i have month and year but i want to get date can u help me how to do it. thx