The feed 'Date' (FEEDDATE) rule function allows you to produce the current date of the feed when it is compiled. Use the current date of the feed or add/subtract days from the current date to produce sale price date ranges that are always active.

How to create a rule using the feed date function

1. In the SET section: choose the feed field you would like to apply a feed date to -- for example, Google's [F].[sale_price_effective_date]
2. In the TO section write your function:
   
   • Start the feed date function with [[ (hit 'enter' or click away)
   • Then type FEEDDATE (hit 'enter' or click away)
   • Close the feed date function with two closing brackets ]]
     • Note: you can adjust FEEDDATE by any number of days by using addition and subtraction, such as, -, +, for example [[ FEEDDATE + 30 ]]
3. In the WHERE section: set the conditions for the rule and then click Save

How to set Google Shopping sale price effective date using the feed date function

For example, follow the formula below to SET your Google Shopping Merchant Center feed
[F].[sale_price_effective_date] to a rolling 30-day window, which will make the sale price effective always:

[[ FEEDDATE ]] / [[ FEEDDATE + 30 ]]

Here is this example as seen in the entire rule:

How to use Date condition groups

You can also apply rules to products based on date conditions. For example, if you need to set promotional pricing during a period of time.

You can also configure repricing rules by combining the calculator and feed date rule functions. Learn more about our calculator rule function.

Contact our support team for further assistance with this issue. Be sure to provide any affected SKUs or screenshots of where you are encountering an issue.

Open a support ticket

Related Help articles: 

📌 FAQ: Feed - Why is my feed submission failing?

📌 All-in-one Feed Setup Overview Guide

📌 Request a feed setup by GoDataFeed