Search Results

Search found 12421 results on 497 pages for 'date arithmetic'.

Page 66/497 | < Previous Page | 62 63 64 65 66 67 68 69 70 71 72 73  | Next Page >

  • Django: Is there any way to have "unique for date range"?

    - by tomwolber
    If my model for Items is: class Item(models.Model): name = models.CharField(max_length=500) startDate = models.DateField("Start Date", unique="true") endDate = models.DateField("End Date") Each Item needs to have a unique date range. for example, if i create an Item that has a date range of June 1st to June 8th, how can I keep and Item with a date range of June 3rd to June 5th from being created (or render an error with template logic)?

    Read the article

  • Format a date from a string

    - by Emil
    Hey. I'm trying to format a date from a string into another format. For example: 2012-05-29 23:55:52 into 29/05 *newline* 2010. I just don't get the logics behind NSDate and NSDateFormatter, I think.. Any help will be appreciated. Thanks :)

    Read the article

  • PHP - Get dates of next 5 weekdays?

    - by Dan
    I'm trying to create an array of the next 5 working week days (Monday - Friday, excluding today). I know the working week varies around the world but this is not important for what I am trying to do. So, for example, if today is a Wednesday, I want the dates for Thursday and Friday of the current week and Monday, Tuesday and Wednesday of the following week. I thought this would work: $dates = array(); for ($i = 1; $ < 6; $i ++) { $dates[] = date('Y-m-d', strtotime('+ '.$i.' weekday')); } But for today, it is giving me: Monday 1st Tuesday 2nd Wednesday 3rd Thursday 4th Sunday 7th! Any advice appreciated. Thanks

    Read the article

  • Date difference in minutes

    - by zurna
    I have DateFirstStarted and DateEnded fields in the database. Date values are recorded as DateFirstStarted 04/13/2010 07:00:00.000 PM DateEnded 04/13/2010 09:00:00.000 PM How do I print minute difference between two dates. I tried the following code but it returned something like 999343 Clock = DateDiff("m", objLiveCommentary("DateFirstStarted"), objLiveCommentary("DateEnded"))

    Read the article

  • sql - get the latest date of two columns

    - by stacker
    table1 - date1 datetime not null - date2 nvarchar null I want to get the latest date of this two. select date1, date2, (CASE WHEN date1 > CAST(date2 as DateTime) THEN date1 ELSE date2 END) as DateTime) as LatestDate from table1 please note that date2 can be null. in this case, date1 win.

    Read the article

  • Trigger email on specific date

    - by Risho
    I have C# web application that I want it to send out an email on a certain date, such as if equipment isn't returned on the day it was due. Data is in MS SQL database. I've got all the email code already done, and I'm just curious how do I trigger this email, say after the COB on that particular day? Thanks, Eric

    Read the article

  • Help with MySQL date operation

    - by jartaud
    Hello i have two columns: duration (int) and dateCol (date) in a table. How should i proceed if i want to know when CURDATE() - dateCol will iqual to duration. ie: CURDATE() - dateCol (2010-05-08) = duration (14 days), and then send an e-amil?

    Read the article

  • Porting Oracle Date Manipulation

    - by Grasper
    I need to port this following from Oracle syntax to Postgresql. Both FLO_END_DT and FLO_START_DATE are of type DATE in Oracle, and TIMESTAMP WITHOUT TIME ZONE in Postgresql: SELECT TRUNC( TO_CHAR(ROUND(( FL.FLO_END_DT- FL.FLO_START_DT)* 24), '9999D99'),2) FROM FLOWS FL I am not familiar enough with Oracle to know what it is trying to accomplish. Any ideas?

    Read the article

  • How can I convert a timestamp to a user-friendly time string

    - by Steve Neal
    I want to be able to present "today" and "yesterday" for recent dates in my application. I've got a date formatter in use currently to show dates (retrieved from data records) and will keep using this for anything more than a couple of days old. I just really like the way the SMS app in the iPhone shows dates for recent messages and would like to emulate this. The time-stamps that I have to work with are generated on a server that the phone downloads the data records from. All times are therefore generated at UTC (i.e. GMT) time. I've been fiddling about with this for a while the solutions I've devised just seem horribly long-winded. Can anyone suggest how to implement a method that could do this? Cheers - Steve.

    Read the article

  • google apps script DateItem get dropdown box

    - by user2117613
    So using Google Apps Scripts with a Form, I'm able to get all the items and iterate through them using the following: var form = FormApp.getActiveForm(); var items = form.getItems(); var item; for(var i = 0; i < items.length; i++) { item = items[i]; if(item.getType() == FormApp.ItemType.DATE) { item = item.asDateItem(); item.dropdown.month; // I need a method like this } Logger.log("ItemTitle: %s ItemType: %s",items[i].getTitle(), items[i].getType()) ; } I can even get the DateItem that I want. My issue is that I cannot get the dropdown boxes from the DateItem. Does anyone know how to get the dropdown boxes from the DateItem? (Like: item.dropdown.month or item.dropdown.day, etc).

    Read the article

  • Rails and date: get profiles with related ages

    - by Totty
    Hy, I have a profile x, that has a born_date and then i want to get all the profiles that has more or less 5 years. If profile x has 20 years, i want every profile that has between 15 and 25 years. Here i need some date calculations and i dont really know how to do it. You have some ideas? ;)

    Read the article

  • Compare date from database and in program

    - by Simon
    database = new OleDbConnection(connectionString); database.Open(); date = DateTime.Now.ToShortDateString(); string queryString = "SELECT SUM(skupaj_kalorij)as Skupaj_Kalorij " + "FROM (obroki_save LEFT JOIN users ON obroki_save.ID_uporabnika=users.ID)" + "WHERE users.ID= " + a.ToString()+" AND obroki_save.datum= " +DateTime.Today.ToShortDateString(); loadDataGrid2(queryString); I get an error,when i wan't to select the result. Why?

    Read the article

  • Formatting a long timestamp into a Date with JSTL

    - by scubabbl
    I am pulling a long timestamp from a database, but want to present it as a Date using Tags only, no embedded java in the JSP. I've created my own tag to do this because I was unable to get the parseDate and formatDate tags to work, but that's not to say they don't work. Any advice? Thanks.

    Read the article

  • Create folder for todays date on click of shortcut

    - by Ram
    Hi, I have a folder named as 2010. In this I want a folder for each month like "Jan10", "Feb10"....."Dec10" In each month folder I want to create folder for "Todays date" I have create a shortcut for that 2010 folder with Target as C:\WINDOWS\explorer.exe /n, /e, /select, F:\2010 I want a functionality that will execute when I click the shortcut for f:\2010 icon. Any pointer would be great help.

    Read the article

< Previous Page | 62 63 64 65 66 67 68 69 70 71 72 73  | Next Page >