Stack Overflow
Stack Overflow

Questions tagged [maxdate]

143 questions
2
votes
3 answers

SELECT data from another table with max date

I need help with a SELECT query in which I need to join to another table and get record with max date. I have created sample to demonstrate. My last SELECT is incorrect and I need guidance to fix it or if there is a better way in Sql server…
SilverFish
  • 1,014
  • 6
  • 28
  • 65
2
votes
1 answer

C# DateTimePicker Max Date range

I am using datetimepicker which displays the date(which is retrieved from the database). I have run my application on a few machines and I have found that on Windows XP SP2, the max date that can be retrieved and displayed is 2020, but for later…
JingJingTao
  • 1,760
  • 17
  • 28
2
votes
4 answers

minDate and maxDate options are not working in datepicker

I'm using the "datepicker" plugin on my project, it's set to decade view, and I want to disable the future dates, for this I have used the maxDate option but it's not working, my code: $('#data_1 .input-group.date').datepicker({ todayBtn:…
Ranjith M
  • 519
  • 3
  • 6
  • 24
2
votes
1 answer

Left Join on MAX(DATE)

I have 2 tables: Transactions (a) and Prices (b). I want to retrieve the price from table b that is valid on the transaction date. Table a contains a history of article transactions: Store_type, Date, Article, ... Table b contains a history of…
Niels Perfors
  • 92
  • 1
  • 1
  • 7
2
votes
2 answers

Set the maxDate and minDate in cordova datepicker plugin

I am trying to add Native Date picker in my project and the plugin is below, 1st pulgin: cordova plugin add https://github.com/DURK/cordova-datepicker-plugin (or) 2st plugin: cordova local plugin add…
san
  • 214
  • 1
  • 10
2
votes
3 answers

Jquery UI Datepicker adds a month to minDate and maxDate

I have a Jquery UI datepicker on my site, but when i choose minDate and maxDate it adds a month to each variable, why is that and how do i fix it? var startDate = new Date(2014, 2, 24); var endDate = new Date(2014, 3, 24); FIDDLE
Legarndary
  • 957
  • 2
  • 16
  • 37
2
votes
1 answer

LINQ Left Join on Max Date

Ok so here are my tables in the database: CREATE DATABASE Temp GO -------------------------- USE Temp GO -------------------------- CREATE TABLE Table1 ( Table1Id INT IDENTITY(1, 1) , Name VARCHAR(20) , …
Cătălin Rădoi
  • 1,804
  • 23
  • 43
2
votes
2 answers

DatePicker input minDate maxDate

On Datepicker I can set a minDate and a maxDate. When i click in the selector it works fine in the calendar that appears. But the user can type the date on the selector, and are able to put a date out of the range that I set. If I press "ENTER" in…
MarceloMadnezz
  • 297
  • 6
  • 16
2
votes
1 answer

Getting date object from jquery ui datepicker maxDate option

By using the following var maxDate = $( ".selector" ).datepicker( "option", "maxDate" ); The output can be anything from '+1M','+20Y', '12/12/2013' or more.. Are the '+1M' & '+20Y' examples something that can be used with native javascript to add…
Matthew Grima
  • 1,513
  • 5
  • 25
  • 40
2
votes
3 answers

How do I improve query to select records with MAX date that uses joined tables in PostgreSQL?

I have three large tables as follows... property -------- property_id other_prop_data transfer_property ----------------- property_id transfer_id transfer -------- transfer_id contract_date transfer_price I want to return a list of unique…
Stan Bridge
  • 79
  • 8
1
vote
0 answers

How can I find the latest completed date that is before a date in SQL Server

Using SQL Server, I am trying to get the latest date a client completed an assessment that is less than the current date (or census date in this case). This query should roll through every day of the client census, and if the client is on the census…
Dcrow01
  • 21
  • 2
1
vote
1 answer

MySQL Max of a Date not returning the correct tuple

I have a table "messages", that stores messages sent to people over time, regarding some items. The structure of the messages table is: message_id user_id date_sent created_at For each user, I can have multiple tuples in the table. Some of these…
Rob
  • 13
  • 2
1
vote
1 answer

Select which has matching date or latest date record

Here are two tables. ItemInfo Id Description 1 First Item 2 Second Item ItemInfoHistory Id ItemInfoId Price StartDate EndDate 1 1 45 2020-09-01 2020-09-15 2 2 55 2020-09-26 null 3 1 …
Atharvan
  • 13
  • 2
1
vote
1 answer

SELECT max(date) return the latest record but the wrong data

I have multiple records all with the same user_id and each with its unique TIMESTAMP. I need to return the correct data for a user_id based on the latest date - MAX(date). My query returns the last date but the incorrect data (ie Data associated…
Anthony Lange
  • 11
  • 2
1
vote
0 answers

Mapping to userID who updated record while grouping by last update date

Ive a got a CTE and grouping by last updated date to get last record updated, however I have to remove the 'Updated By' & 'updated by name' column from SELECT & GROUP BY to get what I want. This is due to cases where a record has been updated at…
Andrew
  • 31
  • 3
1
2
3
…
9 10