Hi guys,
Can someone advise how I need to do this please?
I have a column which has varying numbers i.e. 10, 11, 12 etc. Let’s say this is called: ‘Days’.
I have a new column I have setup whereby I want to do this:
Take ‘Start Date’ (column) and subtract the number from the ‘Days’ column. So if I input a search for a customer, I want to tell them the date of when they get access to a booking by looking at the ‘start date’ subtracted by the days. Can anyone advise?
image attached. you can see the first column has dates and then the second column has '28'. this represents days before a customer can view there booking. I want an SQL to write in the third column the date that a customer can view their booking based on the number of days in the 2nd column. I.e. 28 days from their start date (column 1) is when the booking can be viewed. Thank you for any help in advance!
Thank you!