1,613 questions
1
vote
1
answer
79
views
How to get date difference from a column?
The calculation for the difference between each date is working fine except for the minus sign daydiff column. My requirement is to remove the minus in daydiff column.
The table below is how it's ...
- 75
0
votes
0
answers
13
views
create a date difference generatedfield in model
I want to create a generatedfield that stores the # of days between today and another date field in my model. Currently I have the following:
class Orders(models.Model):
`Order_ID = models.CharField(...
- 1
0
votes
1
answer
80
views
Computed Field fails because ANSI_WARNINGS = OFF
I am trying to have an auto-computed column to tell me the difference in hours between the 2 dates.
It will not let me do it because the database has ANSI_WARNINGS = OFF.
I know the best practice is ...
1
vote
1
answer
59
views
VBA - why am i getting the following error for my code? - "compile error: expected array"
so I have a bit of code that should check the dates in columns AR and AS for each line. Then calculate the difference and populate in column AV. However I am getting a compile error on Datediff for ...
- 21
0
votes
0
answers
15
views
How to get the report between certain date range in Cognos per month
I need a report to schedule out every month with the current maturity date associated with that scheduled period. For example, I want to send out a December report with all December current maturites ...
1
vote
1
answer
28
views
Deriving a calculation for re-orders by date and customer name
I am trying to derive a calculation for re-orders by date and customer name. With the output being in "weeks". And if its easy to switch between "days" and "months" as ...
- 518
0
votes
2
answers
166
views
Snowflake task to remove records older than 14 days not including weekend days
I have created a table 'target_table' to hold daily snapshot of a source table. This target_table is updated via a task that inserts a snapshot of the source table every day and adds/assigns the date ...
- 23
0
votes
1
answer
171
views
Does including ‘today’ in the Datediff function mess up the automated calculation?
Background: I use RedCap to track expiration dates for temporary appointments in my department. The specific issue I am having is with a calculated field I use to track how many days are remaining ...
- 3
-2
votes
1
answer
31
views
Measure to calculate date difference between action date and the date before
I have a table in power bi as below:
User id.
First date
Last date
X.
5 july 24
15 july 24
X.
15 jun 24
20 june 24
X.
3 apr 24
17 apr 24
I need a measure to calculate date difference between first ...
1
vote
1
answer
876
views
How can I get the number of days from a date range filter in Looker studio?
I got a report in Google Looker studio. In one field I need to divide the value by the number of days, according to the selected period. I understand that I can use the date_diff function, but how can ...
0
votes
2
answers
114
views
SQL Issue: calculated query column won't recognize day interval in DateDiff?
For some reason I can't get my calculated query column to recognize a day interval. Every time I test run the form that displays the query results, a parameter pop-up asks me to enter the value of d.
...
3
votes
2
answers
95
views
How to get the test with the highest score if enrollment date and test date are the same?
I have a dataset and I am trying to test the efficiency of a pre-enrollment course. I have enrollment date, test date, subject and the results. The students are grouped into
group 1 - 30 days before ...
- 55
-1
votes
1
answer
185
views
SQL Query CASE Clause when > 180 days between TransactionDate for same MemberNumber
probably a simple request but a rookie like me can't seem to figure it out.
I just need a query that generates results when there is > 180 days between the TransactionDate for each MemberNumber. ...
- 3
0
votes
2
answers
38
views
Joining two MySQL tables where timestamp is not same in both
I have two tables 'poolTemp' and 'weather'. Both tables contain the columns "timeStamp" and "tempC". I want to join the tables with both "tempC" but only when poolTime....
- 11
0
votes
1
answer
50
views
MySQL Query to fill a gap of data
I'm managing a DB which had some problems and I was asked to fill the gap where the database wasn't reading with previous data which was already there. So, the table sensors doesn't have data between ...
