Questions tagged [relative-date]

48 questions
1
vote
1 answer

Updating the relative time in android

I am developing a Twitter client application. As with other twitter clients, I would like to display the relative time of tweet with respect to the current time. I am using a list view and a Simple adapter that binds to an arraylist which stores the…
rajaramyadhav
  • 357
  • 1
  • 7
  • 18
0
votes
0 answers

SAP BO: Calculate MTD sales vs. LY same period month up to rolling current day period

Creating an automatic sales report. We are comparing current year MTD sales vs. last year same time period. (Day period level) MTD Sales Ex: March 1, 2023 -> March 8th, 2023 = Total of $4,350 in Sales MTD sales (this will update automatically as the…
0
votes
2 answers

How do I model "relative" time in a database?

Clarification: I am not trying to calculate friendly times (e.g., "8 seconds ago") by using a timestamp and the current time. I need to create a timeline of events in my data model, but where these events are only relative to each other. For…
Matt Norris
  • 8,596
  • 14
  • 59
  • 90
0
votes
1 answer

Is there a standard to represent relative date codes?

Is there a standard or at least generally accepted convention to represent relative dates? For ex., -5d => 5 days ago 5d 4m 3s => 5 days, 4 minutes and 3 secs where units are y, M, d, h, m, s Note that I checked on the question but that talks about…
metasync
  • 338
  • 1
  • 10
0
votes
1 answer

How to add a relative date filter in Outsystems?

I've built a dashboard with many widgets using Outsystems. I've set up a date input parameter where the user can filter all the data by start date and by end date. This all works great, but now I want to add an option to filter using relative dates.…
Noam
  • 1
  • 1
0
votes
1 answer

Start Date Filter/Set with Most Recent Saturday and Go Back 28 Days

I have a tableau dashboard where I would want to add a button which, when clicked, filters the data to the most recent 28 day period ending on the last Saturday. So if today is Tuesday 8/11, clicking the button would start at Saturday, Aug 8th and…
user13203033
  • 123
  • 7
0
votes
1 answer

how to get number of days from relative dates filter?

I want to get number of months user selected using Relative Dates Filter? If user entered "Last 3 Months" then I wants to get number of days for 3 months to use these days in another calculated field. Calculated field which is using this is as…
0
votes
1 answer

Show relative time based on timestamp

I'm using Kibana to show the statuses of multiple microservices based on the most up to date value for each. I would like to replace the April 8th 2019, 14:37:13.173 format with somethine like 2 minutes ago or 2 minutes 21seconds ago. I know I can…
0
votes
1 answer

R heights graph - relative to birth date

I have a group of people, with a space-separated text file for each person. In these files, the right value indicates the height of that person in cm and the left value indicates the date in %d/%m/%Y format: 09/05/1992 0 17/03/1993 50 02/08/1994…
Zaz
  • 46,476
  • 14
  • 84
  • 101
0
votes
2 answers

SQL Oracle - Count of repeat call within a relative data range

I am trying to mark calls by a customer as repeats, if they have made a previous call in the proceeding 5 days . If they have had more than one call in the preceding 5 days I want it to show as a count. I can do this for a static date range, but not…
user1444329
  • 37
  • 1
  • 5
0
votes
2 answers

Relative NSDate with result TheDayBeforeYesterday,Yesterady,Today,Tomorrow

I want to check for the date and get the result in 4 Format TheDayBeforeYesterday,Yesterady,Today,Tomorrow. I have One date and i want to compare that date with the current Date. Right now i have done this but this is just give me the Day in…
BhavikKama
  • 8,566
  • 12
  • 94
  • 164
0
votes
2 answers

How to get the last first day of September relative to a given date?

I have theater shows dates in several cultural seasons. A cultural season is from the first day of September to the last day of August. Using PHP, I need to know the year of the "last first day of September" relative to the date of the show to…
yom
  • 13
  • 5
0
votes
2 answers

How to implement the "Member for " interval like SO in PHP?

Possible Duplicate: How do I calculate relative time? It shows 2 days,2 month,1 year and so on. How to do it?
Misier
  • 1,455
  • 4
  • 13
  • 15
0
votes
1 answer

PHP relative date filters in Drupal 7 view

I'm building a view in Drupal and am having an issue setting the filter criteria around a date. I have a content type of "film of the week". It stores basic film attributes such as film name, director, guidance rating, starring, etc etc. It also has…
lunchboxbill
  • 191
  • 3
  • 15
-1
votes
1 answer

How might I format relative dates the way Stack Overflow does "member since" and "last seen"?

Possible Duplicate: How do I calculate relative time? I want to know how to display these data as seen on stackoverflow.com profile page. I have the timestamp of users registered date and last visit date. But I need to display using…
Vivek
  • 4,526
  • 17
  • 56
  • 69