Stack Overflow
Stack Overflow

Questions tagged [maxdate]

143 questions
0
votes
3 answers

How to group by max date with un-unique field

What would be the best SELECT statement to get max Event date to achieve the below mentioned Desired Table? Scenario : An Order Can have multiple events in its lifecycle.. like Order Cancelled Event, order placed on hold event.. etc.. and each event…
Lokapedia
  • 105
  • 1
  • 4
  • 12
0
votes
1 answer

How to get Max date with selected row id in Mysql

I have a scenario in which i want to get Maximum Date but not from Whole Table Just from Selected id but i failed. Here is my table I run This Query For get my selected id SELECT * FROM `tbl_methodology` WHERE FIND_IN_SET(6,…
sunny
  • 1,511
  • 5
  • 20
  • 57
0
votes
1 answer

SQL Server - Max Date for multiple records & related data

I have 1900 locations that I am trying to find the max(date) that an order was placed. And also the order cost and order quantity for that related location/date. How do I build a sub-query or join in order to retrieve this data. Example attempt…
rashaad_hannah
  • 3
  • 1
0
votes
1 answer

pickaday maxDate issue

I am creating a date picker by using pickaday but I'm getting stucked and confused with maxDate functionality. I set maxDate 7 years back but when I click on input to select date it shows me current month and year with all dates disabled, I want to…
Kamal
  • 2,140
  • 8
  • 33
  • 61
0
votes
2 answers

Microsoft SQL Server : max date joining two tables

I am attempting to join two tables while pulling the max date from one. I have a student table and a communication table. Each student is unique in the student table and has many communication entries. I would like to create a SQL script that pulls…
aksum
  • 3
  • 1
0
votes
1 answer

SQL Access 2007/2010 Selecting Max Date with Distinct ID

I believe a lot of people have already asked this question as I have read all the topic from here. But the Problem is I have 3 related tables instead of 2 and I'm not sure how to code for that I have a table: tbl_Instruments, tbl_Record and…
Jason Chan
  • 45
  • 10
0
votes
1 answer

G00fy angular-datepicker maxDate isn't working

I have a question concerning angular-datepicker I can't get the max-date functionality to work on my project. I've tried several ways to pass the maxDate variable (set to current day = new Date() ) but nothing happens. This is my markup: div…
MiguelRivero
  • 137
  • 1
  • 9
0
votes
1 answer

SQL, Return Records for last batch run by As of Date

I have a table where the AsOfDate has multiple BatchDates: >Cmmt || AsOfDate || BatchDate > >6789 || 2016-02-11 00:00:00 || 2016-02-11 09:32:05 > >6789 || 2016-02-11 00:00:00 || 2016-02-11 11:48:22 > >2598 || 2016-02-12 00:00:00 ||…
Mike
  • 133
  • 1
  • 1
  • 13
0
votes
2 answers

How to retrieve records with max `delivery date` for each `order number`

I am looking to retrieve all the the records and columns by order number of a table TEST where for a each order number the MAX of the column orderDeliveryDate is equal to yesterday. The following code does not work: SELECT T.* FROM TEST T …
Arnaud Martinn
  • 95
  • 2
  • 11
0
votes
1 answer

How can I create a query which yields the MAXDATE for each order?

I have a table called TEST with 5 columns: clientName, clientID, productNum, orderNum, orderDeliveryDate, and thousands of rows. It basically stores orders. Each order can be composed of several product items, and each product item can have a…
Arnaud Martinn
  • 95
  • 2
  • 11
0
votes
4 answers

jQuery UI Datepicker minDate changes adjust the calendar; how can I freeze it?

I have a five-month Datepicker inline calendar. startDate is a variable I wrote which is set by a user click event. I am adjusting the minDate and maxDate options after init by doing…
John Burgoon
  • 21
  • 2
0
votes
2 answers

Selecting the most recent record for a customernumber

I have the following in a table: Account Name CustomerNumber ReadingValue ReadDate LISA DODDS 96000293474 35568 2015-05-26 23:00:00.000 TONY DODDS 96001750513 54672 2014-08-26…
Jay
  • 3,012
  • 14
  • 48
  • 99
0
votes
2 answers

Query to return the Max(Date) and other table fields based on a primary table list

I am hoping somebody out there can help me with a query problem I can’t seem to resolve; I have two tables; Table1 T1_ID T1_Serial Table2 T2_ID T1_ID –lookup to Table 1 T2_Date T2_History Table1 Data might look something like this; T1_ID …
Jeff Mitchell
  • 11
  • 2
0
votes
2 answers

Select max date by grouping?

PLEASE will someone help? I've put HOURS into this silly, stupid problem. This stackoverview post is EXACTLY my question, and I have tried BOTH suggested solutions to no avail. Here are MY specifics. I have extracted 4 records from my actual…
SteveS
  • 33
  • 1
  • 8
0
votes
2 answers

Can I get the max date of a group without doing a self join?

I have this monstrous query here: SELECT t.technician_id AS techID, CONCAT(t.first_name, ' ', t.last_name) AS technicianName, h.date, p.name FROM technician t JOIN technician_date td ON t.technician_id = td.technician_id JOIN hours_input_on_date h…
AdamMc331
  • 16,492
  • 10
  • 71
  • 133
1 2 3
…
9 10