I am trying to use math field for a date field and then I could use it in views. Let's say I have a "start date" field that a user fills in; I want the math field to calculate the following: [field_start_date:0:value] + strtotime ('+7 days')
There are some unknown areas in here; first of all, the Math field only keeps data in numerical format I don't know how to deal with it since I am trying to calculate and keep date. Second, how can I do the equation get to work, is my above equation good or not? And third how can I compare it in views with "now"?
Thank you