I want to create a view in which there are two fields start date and end date. I want to display one more field that is (difference between the start date and end date). All this three fields should be displayed in table format. So please tell me how to find difference between two dates using views?And i want to display this difference between the date fields as third column of the table.
drupal views difference between two dates
1.6k Views Asked by sneha.s At
1
There are 1 best solutions below
Related Questions in DATE
- PLSQL Need REFCURSOR DATE + TIME
- Pandas date ranges and averaging the counts
- javascript date validation to check whether it exceeds exactly next year's date
- How to INSERT date in PHP & Mysqli
- Create a list of sequential monthly dates in PHP given initial date and quantity
- Date parse with Timezone - Android
- RAILS: date_select validation
- Having trouble writing a calendar, I couldn't find a detailed guide answering my questions anywhere
- Julian Date Conversion SQL
- SQL find out how many days into year date is
- Algorithm to find the Gregorian date of the Chinese New Year of a certain Gregorian year
- Angularjs, date input : enter a date manually with a specific format
- How to convert a Microsoft SQL date to a vba string?
- Why does new java.text.SimpleDateFormat("EEEE").format(new java.util.Date(2015, 6, 9)) return the wrong day of the week?
- SQL Column Numeric to DATE
Related Questions in DRUPAL-7
- Drupal access control to custom user profile page
- How to list all child pages of current parent page in drupal 7?
- Drupal location module shows only a portion of Gmap on node page
- How to add a select collection type select list to field collection
- Drupal AngularJS ajax simple ng-repeat update
- PHPStorm Drush on Vagrant
- Drupal: Access A Field in hook_views_query_alter()
- Drupal domain access auto create content
- How to display sibling pages except current page in drupal 7?
- how to merge entity reference relationship field value
- Drupal print breaks when rendering a region
- Drupal 7 treating HTML div with data attribute as text
- All files and folders are not being listed in the imce file browser in Drupal 7
- drupal api returns json causes syntax error, malformed JSON in json_decode function of php
- Drupal module development, custom database tables, pages for managing those data
Related Questions in VIEW
- Serve arbitrary html in angular data bind
- Switching CSS Just for that view?
- Setting % of a background color programmatically
- Change the View BackgroundColor on Tap
- Pass html.dropdownlistfor current value to Actionlink?
- Filter Field in List by boolean value in MVC
- Android How to change icon with button
- frame.origin Change error on View when Table Cell selected
- How to pass a specific model field to views' functions or methods?
- python django class based view and functional view
- django rest framework - adding to views.obtain_auth_token
- Is it possible to draw on an SFML window regardless of views?
- SQL Join Views - Duplicate Field
- Android change layout depending on if statement
- how to merge entity reference relationship field value
Related Questions in DRUPAL-VIEWS
- Drupal: Access A Field in hook_views_query_alter()
- How to display sibling pages except current page in drupal 7?
- View theme override in drupal 8
- Drupal - Edit Views Selective Filters module to rename the option tag
- How to create isotope filter in drupal 7?
- Drupal views reset exposed filters values on change
- Drupal theme Views template modifications
- drupal views difference between two dates
- Using content type URL Alias in Panels
- Edit node after submission on comparing already submitted data in node creation in Drupal 7
- Drupal 7.0 Views 7.x-3.14 Time-based cache is not functioning as expected
- Display unique node using views in drupal
- views result not showing to authenticated users
- Drupal 7: how to return a 404 page not found instead of a view
- Drupal 7 sum grouped fields
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
You can try with Computed Fields. It allows you to define a new dynamic field for any content type (stored in database or computed on the fly), and you can code in PHP the value for this field, using other fields values.
Creating a computed field to store two dates fields difference is one of the example in the module doc :
https://www.drupal.org/node/149234
Then in your view you just have to display the computed field (and the two original fields).
Views PHP can do the trick as well, it allows you to create a new field within a view, which will be computed in PHP. You can use other fields values to calculate its value.
But I would recommend Computed Fields, Views PHP can be a performance killer.
Good luck