Stack Overflow
Stack Overflow

Questions tagged [maxdate]

143 questions
0
votes
1 answer

MYSQL: Select MAX date from multiple columns

I'm having trouble with a SQL query. This is my purchase table: id email status date 1 user1@server.com confirmed 2014-10-01 2 user1@server.com confirmed 2014-10-02 3 user2@server.com …
Gerardo
  • 159
  • 1
  • 12
0
votes
0 answers

DateTimePicker - Setting MaxDate on DropDownEvent

OK, so I am trying to add some functionality to the DateTimePicker control in my application. The affect that I want is to set the max date without it affecting what the user is typing in. For example, if the value of the DateTimePicker is set to…
Weebie
  • 230
  • 1
  • 14
0
votes
1 answer

Show unique value for id, based on latest createby date

I am using the following SQL code to JOIN a few tables, but need to show unique values for the s.incidentid based on the latest s.createdate. I know I need to use a Sub query with Maxdate, but I am not sure on the correct syntax. This is my first…
user3580480
  • 442
  • 7
  • 14
  • 45
0
votes
3 answers

ridicilous mindate maxdate error while settting datetime

i am writing a desktop application in c# using VS2013. I am getting an absurd error that has not to be produced, in my opinion. I am setting a DateTimePicker's MinDate and MaxDate properties somewhere in the code in such way: DateTime minDate =…
ceskin
  • 13
  • 5
0
votes
2 answers

Update Statement Using Max Date and userid as the criteria

So I am trying to Update a contract table where the Contract Start Date is the latest date and the relevant employee id. The Contract Table stores all past information about the…
xerocool
  • 13
  • 3
0
votes
2 answers

Select Max Date for same employee in two different table

I have two tables with employee information and I want to select the record with latest date between those tables. Table1 EmpNum Name StartDate refrance 1234 John 05Dec2009 999999 1255 Carl …
Mr.M
  • 1
0
votes
2 answers

Selecting MAX date with WHERE clause

I have a table named technical where can I place the WHERE clause for my search function? I want to insert the WHERE t1.blklot LIKE '01/01' - this line will display only those blklot = 01/01 SELECT * FROM technical t1 JOIN ( SELECT blklot,…
nineinchtrent
  • 1
0
votes
1 answer

Clients with no invoices created in last 6 weeks, MySQL

I am having a hard time listing all the clients for which no invoice has been created in the last 6 weeks.Two tables are involved, client and invoice. My current query looks like this: select MAX(invoice.created_date) 'Last Invoice Date',…
Erind Pepi
  • 25
  • 4
0
votes
1 answer

SQL Server: get newest (most current) date per group

I have an SQL table with a column categoryX that contains dates (format: yyyy-mm-dd). How can i group the table by categories in this column and get the newest (most recent) date for each group ? I am looking for something similar to the below…
user2571510
  • 11,167
  • 39
  • 92
  • 138
0
votes
1 answer

How to get the max date for multiple conditions

A bit new to Oracle specific SQL syntax, more familiar with MS SQL Server. I'm having trouble with a join. Specifically, the join is supposed to allow me to return the most recent date from a table. (In SQL Server I would just put select top 1 date…
Christopher Robinson
  • 143
  • 2
  • 2
  • 9
0
votes
1 answer

Mysql query for latest value when date is missing

I have a table with a date and value column. The table is populated daily with new values. On occasion the population does not take place. I need to generate a report of the latest value on each past Monday. This query shows that no data was…
user2225048
  • 1
0
votes
2 answers

Summing Multiple Records by maxdate

I have a table with the following data Bldg Suit SQFT Date 1 1 1,000 9/24/2012 1 1 1,500 12/31/2011 1 2 800 8/31/2012 1 2 500 10/1/2005 I…
user1689297
  • 1
0
votes
1 answer

find maxdate and mindate when grouped

DB table TYPE DATE PLAYER MINUTE --------------------------------------- starter 2000-01-01 Tom starter 2005-01-01 Tom starter 2005-01-01 Ben starter 2010-01-01 Tom subbedin 2012-01-01 Ben …
user1317885
  • 115
  • 1
  • 4
0
votes
1 answer

How can I set the maxDate for mobiscroll?

I´m wondering how I could set the max date on the mobiscroll. I know that i should use the maxDate option but I cannot find how the string should be formatted anywhere. Can anyone help? Thanks
PaperThick
  • 2,749
  • 4
  • 24
  • 42
-1
votes
1 answer

MAX date problem I've tried two solutions I've found but the results dont match

I am trying to find the Max date (latest date) for each accountid in my table FilteredVisit. In my table I have the fields: accountid, casereference and visitdate. I want the latest date for each accountid. Some have multiple visits some only one…
Rhod
  • 1
  • 1
1 2 3
…
9
10