Stack Overflow
Stack Overflow

Questions tagged [period]

A period of time is an interval, a span of time. You can also use it for questions related to the actual punctuation mark.

508 questions
0
votes
1 answer

Power Bi : visualization problem with year over year change

I have created a visualization that gives me the percentage change in the number of sales from one year to the next. This visualization varies according to a date filter. I have data since March 1st 2021. Here is my problem: If I filter on the…
Alex
  • 59
  • 5
0
votes
1 answer

Regex expression for ISO 8601 duration

I've been looking at ISO 8061 Wikipedia - https://en.wikipedia.org/wiki/ISO_8601#Durations I want to create a regex so that: Allowed Input P1Y // date component only P5W Not Allowed Input P1Y5W // No Year, month, week together. Just one of…
thqdqe
  • 3
  • 5
0
votes
0 answers

DAX period filtering (startDate & endDate works weird with months)

I'm working on some DAX query relying on a date difference. My FILTER seems to be working in most cases except when the month of @StartDate is higher than the month of @EndDate. Here is the query : , FILTER ( VALUES('Date'[Report Date]), …
Limon
  • 9
  • 6
0
votes
1 answer

Get Consecutive time slots per Employee

I have a table called slots with identity (id). ID Employee Times Available 1 Anna 1900-01-01 07:00:00.000 0 2 Anna 1900-01-01 07:15:00.000 0 3 Anna 1900-01-01 07:30:00.000 1 4 Anna …
PanosPlat
  • 940
  • 1
  • 11
  • 29
0
votes
1 answer

How to add periods in between letters in C Programming

I am new to C programming, and I am trying to figure out how to put a period in between letters. This is my code: #include #include #include void CreateAcronym(char userPhrase[], char userAcronym[]) { int i; int count…
user17918412
0
votes
1 answer

Need previous pay period - current query only shows current pay period

The current query only displays the current pay period we are in. I am tasked with getting the previous period as well. I can't figure out what would be the best way to filter it in after the prompt. SELECT Table__1."WORK_CENTER", …
ohsapman96
  • 1
  • 2
0
votes
1 answer

How to display in sql records of past Month (not last 30 days) and update them every 2nd calendar date of the next month?

I am trying to represent data for the past MONTH so for example 30 days from April 2nd and continue to update data every month so that on May 2nd, data shows for the 30 days prior to May 2nd. I will show my current code: SELECT 'Working Equipment'…
Farida Bayramova
  • 63
  • 6
0
votes
1 answer

PowerBI DAX How to get records with selected values and startdate and enddate

I have 4 selected values connected to dimDate and dimDate2 (copy) dimdate(startyear,startmonth, dimdate2 (endyear, endmonth) connected to 2 columns startdate and enddate in another table Here is the data I want to be able to filterout rows…
Jonas
  • 185
  • 4
  • 16
0
votes
0 answers

Working with different frequencies in pandas.Period

I am reading dates in the formats "YYYY", "YYYY-MM" and "YYYY-MM-DD" from EXCEL to Pandas data frames and using pandas.Period to sort and compare them. Most dates have years, months and days, so my script currently expects "days" as the default…
OnceUponATime
  • 450
  • 4
  • 12
0
votes
1 answer

Generate new date based on start date and period in Java

So I have: Date startDate which is Sun Mar 27 17:32:01 EEST 2022 and String period which is PT240H And I need to generate a new date based on those 2 values. I need to add that 240H period to the startDate. The 240H meaning 10 days which I need to…
paulalexandru
  • 9,218
  • 7
  • 66
  • 94
0
votes
2 answers

Python - generate a timestamp table in pandas given a date period

This is kind of a mixture between these two questions: Pandas is a Timestamp within a Period (because it adds a time period in pandas) Generate a random date between two other dates (but I need multiple dates (at least 1 million which I specify with…
Munchkin
  • 857
  • 5
  • 24
  • 51
0
votes
1 answer

Pandas DataFrame - Generate Semi-annual Period Index

Currently, I can generate quarterly, monthly and yearly index by changing frequency in following code. df['period_index'] = pd.PeriodIndex(df.Date, freq='Q') Is there a way to tweak freq and get semi annual index?
Lopez
  • 461
  • 5
  • 19
0
votes
1 answer

Interval type without time in PostgreSQL

I'm using PostgreSQL type INTERVAL in pair with java.time.Period type on application side. What I want is to restrict insertion into INTERVAL column of all fields except year, month and day. I know that there's [ fields ] part in INTERVAL type…
RomanMitasov
  • 925
  • 9
  • 25
0
votes
2 answers

Excluding overlapped period in doctrine QueryBuilder

I have Product and Booking entity and I'm trying to select products that aren't already booked in a given period. In other words, to select available products during a given period. To make myself understandable, see the schema below. I only want to…
Benjamin
  • 341
  • 4
  • 15
0
votes
1 answer

calculate mean of period in lubridate

How to calculate mean of period in lubridate ? library(lubridate) # tibble tbl <- tibble(time_1 = ymd_hms(c("2021-01-01 12:00:00"), ("2021-01-01 12:12:36"), ("2021-01-01 14:25:45")), time_2 = ymd_hms(c("2021-01-01 12:12:36"),…
SiH
  • 1,378
  • 4
  • 18
1 2 3
…
33 34