VL Tech Design

Thanks, the product availability field is a date in the format YY-MM-DD. Essentially, the rule could be something like: If availability date > current date, product status = pre-order, else product status = in stock.