Hello
I have a table with two fields ( date and flag)
I need to find the max Month no. then update flag of the records with 2 months older than max month .
ex ; 08/01/2021 then max month is 8
update flag for records with month less than 6
could you give me a hint how to do ? what should be written in queries and its criteria ???
Thank you in advance
I have a table with two fields ( date and flag)
I need to find the max Month no. then update flag of the records with 2 months older than max month .
ex ; 08/01/2021 then max month is 8
update flag for records with month less than 6
could you give me a hint how to do ? what should be written in queries and its criteria ???
Thank you in advance