im working on a database for work and i am trying to set up my table to input a date from a priveous date.

for example:

the date i have from a priveous field is 1 dec 2006 and i would like to subtract 150 days from that date to go into the new field.