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
- Using JQuery Date Slider
- Get Type Error when using .countDocuments with mongoDB
- Gsheet - Automatically send an email using a date & time in a Cell
- Market share growth versus last month, last year
- Convert date string into a number in Python
- Date formatting "yyyy-MM-dd hh:mm:ss +0000" to "dd MMM" in swift
- How does Big Query differentiate between a day and month when we upload any CSV or text file?
- Event_date reference in CTE
- Laravel Nova 4 format date in BelongsTo field
- how to count days elpased between each interval using mySQL?
- MariaDB incorrect dates
- Date issue - how do I parse date in this SQL
- Countdown to varying payday in Javascript
- Can I have a static ISO8601DateFormatter with specific formatOptions in Swift?
- Date Format mdy vs dmy
Related Questions in DRUPAL-7
- Drupal 7 saving content each time i upload an image
- In which database table is the list of files attached to a node?
- Upgrade the drupal 7.88 to drupal 10.1.1
- Drupal 7 to Drupal 9 through web browser upgrade - "files do no exist"
- I've received an export 'network error' in attempt to export a database from phpMyAdmin
- Drupal 7 Incorrect spam bot errors on different browsers
- Drupal 7 | Uncaught ArgumentCountError: Too few arguments to function _drupal_error_handler()
- I need to add a webform block in drupal 7 for a custom theme
- imperva WAF rules blocked drupal 7 form submit
- Issue with Drupal 9 Visitor Counter Module: Visitors Count Not Updating
- how to add Language in drupal 7.09
- Attempt to create field name which already exists and is active
- Can i customize html and css in $page[content] in drupal 7?
- CDK toolbar does not appear on Drupal 7
- PHP refuses update because in server root, Drupal 7 (php7.3) & Drupal 10 (PHP 8.1) on the same server both working - Can't update D10
Related Questions in VIEW
- Opening sheet in SwiftUI view
- Get json field value in sqlite model from view django
- I don't understand which databases are invalid
- View is not refreshing
- Changes to my model/viewmodel are not charging what's on my view
- How to create a text sticker view in swift, like in Canva App, which is resizable as per the text content in it
- SQL Tranformations in view or stored procedure?
- SQL query getting too slowly when using IIF in a view column that is using aggregate results from a previous view. see below example for a clarity
- How to add focus in AndroidView field
- Angular 17 does not update view using setInterval with NG0500 error in console
- How to use std::ranges::set_symmetric_difference over a non sorted range?
- AUTH_USER_MODEL refers to model 'Socialmedia.User' that has not been installed
- Is it possible to show columns really used in a view
- Can't render views of html in django
- Entity Framework Core add relationship between view and standard model objects
Related Questions in DRUPAL-VIEWS
- How to disable cache in my custom contextual filter code in drupal?
- Add own content in views templates - change body display parameters?
- Upgrade the drupal 7.88 to drupal 10.1.1
- Drupal 10: How to do calculations with aggregated results of a row
- How to get the image url to display it in my twig without and with node
- Drupal 10 views: fields/custom text show translated label for field
- Drupal 9 view for webform field summaries
- Drupal 9 Configuration Synchronization Error
- Display links for referenced content item listing pages from within the current node
- Views and Blocks translation
- How to print layout builder sections inside of a twig file in Drupal 8
- Drupal 9 current IP address doesn't change without clear cache
- How I can add a class on hook_form_views_exposed_form_alter on a filter particular radio button
- Drupal 9 - Output Views "Content: Link to Content" url to views-view-unformatted....html.twig template
- How to get access of every result in a view with pagination with a hook in Drupal 9?
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 # Hahtags
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