I have a Query output where i am having two dates, "Expected Date" and "Revised Dates".
Now, i want to have a column which would say " Exp/Rev Date" and should have the value of Revised Date if it not ZERO. IF revised date is zero, that mean 00/00/.0000 or not available, it should show the value of "Expected Date".
It would also want to hide the existing columns of Expected and Revised dates and instead show only the new column which is Expe/Rev date.
Any idea how we can do it at query level in the simplest way ?