Search Results

Search found 1782 results on 72 pages for 'dates'.

Page 40/72 | < Previous Page | 36 37 38 39 40 41 42 43 44 45 46 47  | Next Page >

• Resize Vertical Tick Label Height (XYStepChart)

  - by Vassilen Dontchev

  Hi! I've got the following chart made with JFreeChart: Is it possible (and if it is how) to extend the dates on the x-axis so that they contain the year, eg. 4-II-2010, 5-II-2010, ..., 6-III-2010?

  Read the article

• How do I compare a DateTime column to now() in a query filter in SqlAlchemy?

  - by Ben

  I have a table with an 'expires' datetime column. I want to find all the items that have an 'expires' date earlier than now. I've tried session.query(Item).filter(Item.expires < now()) but it doesn't return anything regardless of the dates in the table. I'm using PostgreSQL 8.4. How do I do this comparison?

  Read the article

• How should i store availability calendar information in mysql? for [id] [date] [available/unavailab

  - by Haroldo

  I'm building a simple calendar for holiday cottages to show when they are booked or available. What would be the fastest mysql table design for this, bearing in mind when users mark dates as available/booked they will do so via a start date and an end date. i can see 2 obvious options Store 'booked' data for every day [more rows] or, store 'booked' data with 2 columns a start_date and end_date [more processing?] Which is best or is there another method i'm missing?

  Read the article

• Date based publishing ASP.NET MVC

  - by kayluhb

  I am building a custom CMS in ASP.NET MVC and one of the requirements is that the content has a start and end date that dictates whether or not the page appears on the site. What is the best approach to this? Should I run some sort of chron job to mark the status of the page according to its publish dates? Does anyone have any resources or advice on the matter?

  Read the article

• C#: Finding Out Which Monday Is The 3rd Monday Of The Month?

  - by Soo

  If I'm writing some C# code that runs through a year of dates (iterating by day) and want something special to happen every 3rd Monday of the month, how can I accomplish this? In other words, what is the best way to find which Monday of the month a current Monday is?

  Read the article

• Getting "AllDay" for every calendar i create in Google apps using .NET google API Ver 2 .

  - by Pari

  Hi, I am creating a calendar in google calendar using Google API ver 2. Problem i am facing is: I am getting all calendar as "ALLDAY". I tried below code: When eventTime = new When(); eventTime.AllDay = false; entry.Times.Add(eventTime); // i am not setting dates as i am assigning them in recurrance data. How to make all day event to false? Thanx

  Read the article

• Is it possible to write a regular expression for finding a typical file matching pattern in config

  - by Thinking

  Is it possible to write a regular expression for finding a typical file matching pattern. e.g. File<13/04/2010.txt should be picked up and not any other file. i.e. Starting file name will be File followed by some dates and then the file extension. If so, can we specify this pattern in the config file? Looking for the solution in C# Thanks

  Read the article

• Is there a decent technique for SSIS Derived Column date formatting?

  - by theog

  I just had to write the most redonkulous expression in an SSIS Derived Column to get dates formatted like "01-JAN-2010".  It lookes like this:        There's got to be a better way... isn't there?

  Read the article

• how to check whether the item in the combo box is selected or not in c#?

  - by zoya

  im having a combo box in which i have to display dates from database...user have to select a date from the combo box to proceed further...but im not able to make the user aware of selecting the item from the combo box first to proceed further...what is the process so that a user can get a message if he has not selected the date from the combo..

  Read the article

• Display Friendly Date, Numbers

  - by user310657

  I am searching for a custom control for asp.net, which helps display user friendly dates, like instead of article date: (2-april-2010) it displays (2 months old) I am unable to find it on google, please can any one suggest links, custom controls, articles for the same. Thank you.

  Read the article

• How to get latest files in C#

  - by Newbie

  I have some files with same name but with different dates. Basically we are finding the files with most recent dates The file patterns are <FileNames><YYYYMMDD><FileExtension> e.g. test_20100506.xls indicates <FileNames> = test_ <YYYYMMDD> = 20100506 <FileExtension> = .xls Now in the source folder, the files are standardization_20100503.xls, standardization_20100504.xls, standardization_20100305.xls, replacement_20100505.xls As can be seen that, standardization_.xls are 3 in numbers but replacement_.xls is only 1. The output will be a list of file names whose content will be standardization_20100504.xls and replacement_20100505.xls Because among all the standardization_.xls is the most recent one and replacement_.xls is also the same. I have tried with my own logic but somehow failed. My idea is as under private static void GetLatestFiles(ref List<FileInfo> validFiles) { List<FileInfo> validFilesTemp = new List<FileInfo>(); for (int i = 0; i < validFiles.Count; i++) { for (int j = i+1; j < validFiles.Count; j++) { string getFileTextX = ExtractText(validFiles[i].Name); string getFileTextY = ExtractText(validFiles[j].Name); if (getFileTextX == getFileTextY) { int getFileDatesX = Convert.ToInt32(ExtractNumbers(validFiles[i].Name)); int getFileDatesY = Convert.ToInt32(ExtractNumbers(validFiles[j].Name)); if (getFileDatesX > getFileDatesY) { validFilesTemp.Add(validFiles[i]); } else { validFilesTemp.Add(validFiles[j]); } } } } validFiles.Clear(); validFiles = validFilesTemp; } The ExtractNumbers is: public static string ExtractNumbers(string expr) { return string.Join(null, System.Text.RegularExpressions.Regex.Split(expr, "[^\\d]")); } and the ExtractText is public static string ExtractText(string expr) { return string.Join(null, System.Text.RegularExpressions.Regex.Split(expr, "[\\d]")); } I am using c#3.0 and framework 3.5 Help needed .. it's very urgent Thanks .

  Read the article

• Get records from a specific month using SQLite

  - by soren121

  How would I write a SQLite query to select all records from a specific month? My dates are stored as Unix timestamps. PHP code is allowed in your solution if it's required. SQLite2-compatible queries only, please. :)

  Read the article

• howto create a new Date() in Javascript from a non-standard date format

  - by Michel

  hi, i have a date in this format : dd.mm.yyyy when i instantiate a javascript date with it, it gives me a NaN in c# i can specify a dateformat, to say: here you have my string, it's in this format, please make a Datetime of it. is this possible in javascript too, and if not, is there an easy way? i would prefer not to use a substring for day, substring for month etc. because my method must also be capable of german, italian, english etc dates.

  Read the article

• How to query by recent date and value in SQL?

  - by wsb3383

  I have a table with three columns: patient_id, obs_date, and weight_val. patient_id stores patient identification #, weight_val stores a weight value, and obs_date stores the date when the weight reading was taken. So, a patient can have many different weight readings at different dates. How do you write a query for: select all patients whose last weight reading is 120?

  Read the article

• Getting page status history in Sharepoint

  - by user307852

  Hi, I need to get all dates and people modifications to currenlty displayed page, all changes which have been published and end user can see difference between them. My page is aspx connected to pageLayout in which is richhtmlfield with article. How to do that? Is it possible to do that ?

  Read the article

• How to find if a date is a valid date, and not greater than year 2038?

  - by user187580

  Hello, I have a site where users provide some dates, but if they enter year like 12 april 2099, then the I get date in the past (1969). How do I check it and apply a default max safe date? thank you.

  Read the article

• What's the easiest way to validate this date format, eg, 31-JUL-2010 (and only this fmt)

  - by George

  I would like to easily validate dates in this format and only this format. Any otehr format should be considered invalid.

  Read the article

• finding the number of 1's in my table in order

  - by bsandrabr

  I have a table of customers with a 1 recorded against their customerid on different dates. I would like to find the sum of the 1's recorded in descending order. I'm using MySQL and php Thanks

  Read the article

• How to convert numbers to words in php

  - by user225269

  Is there a function in php wherein you can convert the number 12 to its equivalent in a month. For example if the mysql database stores digits and not words for dates. how do you convert the number 12 into the word december?

  Read the article

• Create a Calendar that displays one year from today(Asp.Net)

  - by GigaPr

  Hi, I would like to create a calendar that displays a year from today(everyday) and allows the user to select the multiple dates. I tried to use the asp:calendar without any success I am developing in C# .NET any suggestion

  Read the article

• mysql query fails.It gives me invalid result

  - by user2941349

  I have to write mysql query for fetching result from my database with a specified date and code like ABH18 or ABH17 or ABH19.I write the querly like below. select * from tbl_transaction where trans_name like 'ABH19%' or trans_name like 'ABH18%' or trans_name like 'ABH17%' or trans_name like 'ABH15%' and date_of_vazhipad='2013-11-20' and trans_status='Completed successfully.' There are no result in the DB satisfying all above conditions.But i got result with different dates.But i want to ensure the date_of_vazhipad='2013-11-20' so that the query may work properly Thanks in advance

  Read the article

• PHP array question.

  - by TaG

  How do I show the dates number format next to its name in the array using PHP? So that the number format is saved in the database and the month name is displayed? Here is the php code. $month_options = array("Month", "January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December");

  Read the article

• Date difference in SQL Server 2005

  - by naveen

  Hi, I have two dates of the form Start Date: 2007-03-24, End Date: 2009-06-26 Now I need to find the difference between these two in the below form: 2 years, 3 months and 2 days Can someone please … in SQL Server 2005

  Read the article

• finding if an anniversary is coming up in n days in MySql

  - by user151841

  I have a table with anniversary dates. I want a query that returns me rows of anniversaries coming up in the next 10 days. For instance: birthdate --------- 1965-10-10 1982-05-25 SELECT birthdate FROM Anniversaries WHERE mystical_magical_mumbo_jumbo <= 10 +------------+ | birthdate | +------------+ | 1982-05-25 | +------------+ 1 row in set (0.01 sec) I'd like to keep the query in the form x <= 10, because I'll use that number 10 in other parts of the query, and if I set it to a variable, I can change it once everywhere by changing the variable, and not have to re-write the query.

  Read the article

• Given a Date "03/13/2010", using that in a MYSQL Where Clause?

  - by nobosh

  I would like to pass a MYSQL query via Coldfusion the following date: 03/13/2010 So the query filters against it like so: SELECT * FROM myTable WHERE dateAdded before or on 03/13/2010 I'd also like to be able to take 2 dates as ranges, from: 01/11/2000, to: 03/13/2010 SELECT * FROMT myTable WHERE dateAdded is ON or Between 01/11/2000 through 03/13/2010 thanks

  Read the article

< Previous Page | 36 37 38 39 40 41 42 43 44 45 46 47  | Next Page >