Date math in View table Sorry for any incorrect terminology; I'm new to Drupal so it's possible that I'll mess up the Drupal-specific vocabulary.

I'm putting together a View->Page with a Table Format.

I've got a field in my data set called "registrationdate", and I can display that just fine.  However, what I need to display is registrationdate plus 14 days.  I haven't been able to figure out how to add a number of days to the value so I can display the adjusted value.

I know how to do this in SQL, but since Drupal acts as an abstraction layer between me and the database, I can't do so in this case.

Thanks in advance for your help.
You can change the value using a field template.


Add the date field to your view
Look in Advanced -> OTHER -> Theme: Information for a suitable file name for a field template that will only affect the field in this specific view.  They are listed in order from least specific to most specific so the final one in the list for that field is probably the best one to use.  The link on the filename will show you the default contents for such a file.
Create a file in your theme where you keep template files with that filename
Start with the default contents in that file and refresh your cache
Install devel module and use dpm($output) in your new template file to see the structure of the output
Use PHP to edit the appropriate portion of the output, you may need strtotime() and date_add() to achieve this.


Clear your cache often.  If you haven't already got drush installed, do it, it is a very useful tool.