query offset countdown by 2 each day?

There could be several approaches but here is one, which comes in my mind.

Steps with code example:

1. Initially, store the count in Database using Options API like this:

   update_option('offset_count', 1000); 
   
   $current_date = date("d");
   update_option('last_countdown_date', $current_date); 
   

2. Before querying the post, retrieve both values from DB, like this:

   $offset_count = get_option( 'offset_count' );
   $last_date    = get_option( 'last_countdown_date' );
   

3. Now you just need to compare current date with stored date to make your decision. Code would be:

   $current_date = date("d");
   
   if( $last_date != $current_date ){ 
   
       if( $offset_count >= 2 ){
           $offset_count = $offset_count - 2;
       } else{
           $offset_count = 1000;
       }
   
       update_option('offset_count', $offset_count); 
       update_option('last_countdown_date', $current_date); 
   
   } 
   

4. Now just pass $offset_count variable to your query.

It will do the job! 🙂