Adding Days to Date

#1

I am pretty new to generating data. I am trying to get a formula to add days to another date field in the schema. I am getting the following error:
error: Could not access blank value: Use || to provide a default value for blank fields. Example: (my_field || 0) + 1

The formula I am using is for example:

File Open Date + days(3)

I formatted this based on the suggested formulas popup and am confused why its not working or what I should do. Any help would be greatly appreciated.

Link: https://www.mockaroo.com/schemas/81256

#2

You need to wrap the field name in a call to field(). For example:

field('File Open Date') + days(3)
#3

Mockaroo,
It only works part of the time in this example: https://mockaroo.com/schemas/148951. Every other row returns error: argument out of range