HI Anil! What about just taking the maximum of the loaddate_dtm field before extracting the timestamp? That is, wherever [load_date_dttm] appears in the first calculation, just replace that with MAX([load_date_dttm]).
Thanks David .. That worked ...
Small things that we miss will put us in thought process .. I don't know how I missed it
You're welcome! And don't worry, it's easy to miss the big stuff if you're looking at something with a microscope!
Take this example, for instance: Why Even Radiologists Can Miss A Gorilla Hiding In Plain Sight : Shots - Health News : NPR