Forum Discussion
Select MIN of 4 Dates
what do you mean by "current date"? isn't it the same with Date()?
see if the Conditions are met in the new function.
HI Arnel, you are correct that I am not able to Normalize at this point. It would require a lot of rework. I know of this concept but didnt think to apply it to dates. I know this now so a good lesson brought up by George.
I have looked at the db udf and query. It looks great & performs as intended.
I did leave out a point since I was going to figure out a solution on my own but the function I do not understand how to modify and kindly ask your assistance.
What I need now is to return the MIN but I need to consider the current date.
I will try to summarize in english:
(1) If all dates are >Date() ===>return the MIN (as the UDF does now)
(2) Exclude any dates that are <Date() however if all Dates are <current date then return the MIN of those dates that are <current date.
I hope its not confusing. Grateful for the assistance. thank you in advance. Happy to add more detail if needed.
what do you mean by "current date"? isn't it the same with Date()?
see if the Conditions are met in the new function.
- wow that was perfect! Tested and returns exactly as described. thank you very much! Have a good day Arnel / George and thank you for the great assistance and tips about normalization.