Hi, I am new to sharepoint... I have a question: I have a list with many documents in it. I have a date column in that list. For each month I would like to view only that particular month's list (i.e) select the list which has that month in the date field. I would like the list to get updated each month automatically according to the d...
I would like to calculate a new date simply by using the build-in dateadd function, but take into account that only weekdays should be counted (or 'business days' so to speak). I have come up with this simple algorithm, which does not bother about holidays and such. I have tested this with some simple dates, but would like some input if...
As most people are painfully aware of by now, the Java API for handling calendar dates (specifically the classes java.util.Date and java.util.Calendar) are a terrible mess. Off the top of my head: Date is mutable Date represents a timestamp, not a date no easy way to convert between date components (day, month, year...) and Date Calen...
Hi I have a table listing people along with their date of birth (currently a nvarchar(25)) How can I convert that to a date, and then calculate their age in years? My data looks as follows ID Name DOB 1 John 1992-01-09 00:00:00 2 Sally 1959-05-20 00:00:00 I would like to see: ID Name AGE DOB 1 John 17 ...
Hi, I am learning javascript and I am trying to figure out if there is a simple way to convert a standard formatted Date to ISO8601 format (YYYY-MM-DDThh:mm:ssTZD). Advices? ...
I am trying to split a string from a recordset that is in the format DD/MM/YYYY. So basically something like: Homework.Fields.Item("DateDue").Value.split("/") But that doesn't work, Normally I can do: String(Homework.Fields.Item("DateDue").Value).split("/") But using String() turns the value into a long thing like: Wed Oct 26 00:...
I am using the jquery date picker found here: http://www.kelvinluck.com/assets/jquery/datePicker/v2/demo/datePickerStartEnd.html that allows the user to pick a start and end date. However I want to be able to disable specific dates. I tried to implement the code found here: stackoverflow.com/questions/501943/can-the-jquery-ui-datepicke...
I don't get it I want to calculate something I want to check if the time out of the database is before or after this time so I made this. $qVraagCodeOp = "SELECT * FROM `code` WHERE `Code_Code` = '$value'"; $rVraagCodeOp = mysql_query($qVraagCodeOp); $aVraagCodeOp = mysql_fetch_assoc($rVraagCodeOp); $oldTime = mktime($aVraag...
I've got a database of historical records from WW2 and currently each recorded event's date is stored in one integer field as YYMMDDHHMM. This makes simple tasks like ORDER BY, or searching for all events within a certain time period extremely easy. However, if somebody wants all events that occurred on December 1st in any year of the wa...
I am a pilot who flies multiple legs in a day. The software I use to log flights spits out a csv file and lists every leg separately. I import the csv file into table 1 in ms access. I would like to merge all flights from the same day into one record on a new table. My problem is combining the route and adding the time. Table 1 ...
I want to select data between 1 week ago data until today data: SELECT username, email, date FROM users WHERE date(date) BETWEEN (CURDATE() AND (CURDATE() - 7)) ORDER BY userid DESC LIMIT 10 Hope you guys can help me. It does not work!!! This question has been answered by lexu (can somebody close this question?) ...
Hi, can anybody spot any mistake in this function? .. This is a function which receives a string of type yyyy-mm-dd hh:mm:ss aa and converts to UTC and builds up a string yyyy-mm-dd hh:mm:ss. function LocalTimetoUTC(localTime) { var time = localTime.split(" "); //Received :- yyyy-mm-dd hh:mm:ss aa var yearday = time[0].split("-...
Hi all Will any one tell me how to get the current month and previous three months using PHP For example: echo date("y:M:d"); output will be: 09:Oct:20 But i need: August September October as the Output. Thanks in advance... Fero ...
Does anyone know where I can read the documentation for the solution to this warning. I can search for the warning and I just get a phonebook's worth of pages that have the same problem. Anyone? Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are required to use the date.timezone setting...
I have a bash script runned every day via cron. In this bash I want to run some command but only every x day (x is fixed and will be 3, 4 or 5 I don't know at the moment) I can test if the remainder of the division day of month / x equal 0 day_of_month % x = 0 I will work on a single month but not always between to month, for example...
Got a weird bug best shown by this page http://www.zoecormier.com/freelance/ Scroll down to the article named 'Testing turnitin' and you will see the article date is not showing. The article above it (named 'Stolen words') is showing the date. These two articles have the same date, but only one is displaying it. Code for the article li...
I currently have an app displaying the build number in its title window. That's well and good except it means nothing to most of the users, who want to know if they have the latest build - they tend to refer to it as "last Thursday's" rather than build 1.0.8.4321. The plan is to put the build date there instead - So "App built on 21/10...
I am currently using the following PHP code generate a Select Box with different times: <? for ($x = 28; $x < 81; $x++) { if ($x == 48) { print "<option selected='selected' value='" . date("H:i:s", mktime(0, $x * 15, 0, 0, 0)) . "'>" . date("g:i a", mktime(0, $x * 15, 0, 0, 0)) . "</option>"; } else { print "<option value...
I know there are a number of "How do I find the most recent record" questions out there, but none of them quite solved my particular problem: in MySQL, I'm trying to find the most recent record for an entry that's mapped to two different categories in the same table. There's essentially an ENTRIES table with a bunch of info, a CATEGORIES...
What is the easiest or most elegant way to convert a RFC 1123 date (From an HTTP-Expiration-header) to a UNIX timestamp? Example: Sun, 14 Aug 2005 16:13:03 GMT Do I really have to 'substr' everything? ...