Stack Overflow
Stack Overflow

Questions tagged [maxdate]

143 questions
1
vote
2 answers

Find most recent value that meets a condition

In Sheet2 Column C (Plan ID) can have multiple records Column K (Status) can either be "Approved" or "Rejected" Column L (Status Date) I'm trying to make a VBA macro to look through my data in Sheet2 to find the most recent "Approved" Status for…
mcaulifww
  • 3
  • 1
  • 3
1
vote
1 answer

How can I use MAXDATE in MySQL where clause

I am working with a scheduling database for events. I am selecting from series of days and INNER JOINING them into the schedules parent "event". In my selection I want to make a condition where the selection has to be older than the CURDATE. Here is…
silversunhunter
  • 1,219
  • 2
  • 12
  • 32
1
vote
0 answers

How to update minDate and maxDate of Datepicker Android

I have an activity containing 2 DatePickers (From and To) and a Button called "Special request". The first thing i do in my activity is set the minDate and maxDate of both DatePickers. Then by clicking on the Button i wish to update those minDate…
clems36
  • 922
  • 1
  • 13
  • 26
1
vote
1 answer

select minimum date and other column value for maximum date

need to return minimum date and other column value for maximum date like below id name date item 1 First1 24/03/2001 abc 2 First1 20/12/2002 bcd 3 First1 13/02/2003 xyz 4 first2 24/03/2004 nhe 5 first2 20/12/2005 djp 6…
Sam
  • 21
  • 4
1
vote
3 answers

Joining tables then filtering on Max Date

I was wondering if someone could cast their eye over the query I am trying to execute, I can't quite think on the best way to do it. I need the Email, Firstname and Surname from the Contact table and the HotlineID and Last Action from the Hotline…
rjn239
  • 13
  • 1
  • 6
1
vote
2 answers

Using Java SimpleDateFormat to find max date

I haven't programmed in Java for many years, but I now have to change a program I wrote some time ago. In this program I need to read a QIF file and find the qif record with the maximum date (Dmm-dd-yyyy). I could not get this to work in my program…
Michael Adolf
  • 11
  • 2
1
vote
1 answer

Access VBA SQL: Find Max Date and retrieve row ID

I'm using MS-Access 2007 with linked MS-SQL db with 2 tables. One table is the inventory details, the other is the inventory's track, tracking each inventory's status (by ID) on a specific date. I need to retrieve the TrackID for each InvenotryID by…
d.mckeithen
  • 13
  • 1
  • 3
1
vote
2 answers

Select multiple rows with max date

I'm new to mysql so please help me out with this. I have a table containing the following columns: nr | date | hour | user | shop | brand | categ | product | price | promo 183 02/03/14 17:06 cristi 186 brand1 categ 1 …
user3303717
  • 55
  • 5
1
vote
1 answer

jQuery: DatePicker not allowing me to select max date

I'm using jQuery's date-picker and specifying a minimum date of today and maximum date of Jan 31st. When the calendar shows up, however, the 31st cannot be selected, despite the code looking correct. Here's the code: function initializePickers() { …
Bing
  • 3,071
  • 6
  • 42
  • 81
1
vote
1 answer

sql: select average grade for all subjects for one student and print an according message

I have a table student with the following columns: id subject grade date ---|-------|------|-----------| 1 | A | 1 | 01-MAR-10 | 1 | A | 5 | 05-APR-10 | 1 | B | 3 | 01-JUN-10 | 2 | A | 1 | 01-MAR-10 | 2 | C …
IAM
  • 895
  • 2
  • 13
  • 30
1
vote
1 answer

How to return max date based on two other columns?

I haven't been able to track down an answer to this problem, so I am hoping someone here can help. I need to return the max date for each course, for each ID. I have been using a subquery to pick the max date based from one other column, but cannot…
user1563370
  • 75
  • 1
  • 2
  • 8
1
vote
1 answer

Powershell MaxDate Property for Calendar

I have a powershell calendar that allows a selection range of dates. The MaxDate property is set as the current day. The issue I am having is that I can select today's date but not as part of the range. I can select multiple dates but as soon as I…
atownson
  • 368
  • 2
  • 10
  • 22
1
vote
1 answer

jQuery UI Datepicker and Timepicker conflict with minDate and maxDate (Error parsing the date string: Missing number at position 0)

I am using Rails 3.2.11 and am trying to use both jQuery UI Datepicker and Timepicker, however I am facing problems when trying to use the minDate and maxDate properties of Datepicker. My view for one page (in HAML), looks like this: .field_section …
rwb
  • 4,309
  • 8
  • 36
  • 59
1
vote
1 answer

Selecting and Importing Data Correlating with Most Recent Date with Microsoft Query SQL

I'm trying to modify a current SQL code in Microsoft Query I created to return the most recent production test conducted on a well. Right now the query below returns a list of tests for any well from [Date Parameter=01/01/08] to now for [Well…
user1742149
  • 11
  • 1
1
vote
1 answer

Set Maximum Date In Chaining Datepicker

I make a range datepicker with "from date" and "to date". Here code: From To