I've a senario, In that i need to extract last 7 days details using query in AS/400. I tried with MAX function. In that it takes MAX(&CURNTDATE) as whole number and subtract. For example i'm subtracting 7 from today's date (1101027 - 7), i got 1101020. If i subtract 40 means i got 1100987. Can...
Hello, Hope every one doing well. I am planning to implement F9 “Retrieve” functionality in my application. It would be great if any one can provide me the logic to implement the same. Hope you guys can guide me in this regards. Thanks & Regards Bibin George