[date] Forum Topics

Is there any ways to allow the text box in a report to show the lastest date from the database? For example: 24/2/2007 15/4/2009 21/6/2009 14/7/2010 13/10/2010 i want the text box to have 13/10/2010, which is the lastest date out of the 5 date(which I have more in my …

I have these few dates in my database and I would like to have the latest date to be shown at my report footer. 03 dec 2001 15 may 2010 08 mar 2007 14 jan 2004 29 sep 2009 can any kind soul plz help me?=) thx alot in advance=)

Hello again, codegurus. I need to ask your assistance in converting string to datetype, from 'dd/mm/yyyy' to 'yyyy-mm-dd'. The user could key in either the 'dd/mm/yyyy' format or 'yyyy-mm-dd' format in a textbox. the system would check for both format and convert both to the 'yyyy-mm-dd' date format, to be …

Dear friends, I'm doing a PROJECT work in ATTENDENCE... i need to check, HOW MANY DAYS employee IS ABSENT... I need a PL/SQL PROCEDURE to ACCEPT 4 DATES: DATE 1: When he gave the LETTER for LEAVE DATE 2: When he was GRANTED leave DATE 3: FROM - DATE. which …

Hi is there an accepted way to calculate the number of times a specific day would come round in a given timespan? For example if we have 32 as a variable that represents the number of weeks I would then need to find out how many times the first of …

I am working vb.net application vs 2005,I am using culture ("ja-JP") japan in my application but i need to display date in this format("dd-MMM-yyyy") how to change it? Thanks

Hello - I am trying to get a looping date repeater to work but it is driving me crazy! It works for most dates but breaks for dates that originate in early November. I created a page that shows the code and the output for anyone to see what is …

Hello I want to change date format to insert date in mysql. I tried as below code [CODE]<script type="text/javascript"> $(function() { $("#datepicker").formatDate('yyyy-mm-dd'); $("#datepicker").datepicker(); }); </script> [/CODE] but its not working form me. can anybody suggests me how to do it?

Hi there I'm writing to a file so that it creates a back log of the data and time i did something. I've got the program so it writes the data that is needed and also the date and time. the problem is if you use the program more then …

Alright this is a little hard to explain, but I have two tables of very different data. Both tables have a date timestamp. The timestamps are not going to match, but I need to join table2 on to table1 via the next date equal to or less than. So.. Table1 …

am using sql 2005 and vb 2008.i need to compare dates and select matching records betweem a selected date range.say records between 11/13/2010 and 11/20/2010.e.thing is working ok except when it comes to selecting dates between 11/1/2010 and 11/9/2010.this is happening because when am retrieving the dates from database,its being …

Hello everyone, i'm using a jquery datepicker like this: [CODE]<script type="text/javascript"> $(function() { $('#inlineDatepicker').datepick({ rangeSelect: true, monthsToShow: 3, minDate: '+7d', rangeSeparator: '|', altField: '#resdate', altFormat: 'dd-mm-yyyy', pickerClass: 'locgrid', onDate: nationalDays } ); }); var natDays = [[12, 18, 2010], [12, 19, 2010]]; function nationalDays(date, inMonth) { if (inMonth) { for …

hi all, i am trying to create a room booking system in php. now i want to check if a period exists within a given month. i ask the user for the month and how many days they want to come, now i want to look in mysql (where i …

I am using the code below to insert time into a table, and this is the output it's giving me: 0000-00-00 [CODE]//table start DATETIME, //code to insert date into db $_POST['start']=date("Y-m-d H:i:s"); $insert = "INSERT INTO eguardIPs (Field1,Field2,Field3,start) VALUES ('".$_POST['Field1']."', '".$_POST['Field2']."', '".$_POST['Field3']."', '".$_POST['start']."')"; $add_start = mysql_query($insert);[/CODE]

Hi, My sql database contains a video table which has a video 'adddate' field. I need to change the code [COLOR="Red"].$video['adddate'].[/COLOR] from the following format: 2010-11-02 to 11-2010 I've changed it in .tpl files doing the following: {assign var='vidMthYr' value=$videos[i].adddate} {$vidMthYr|date_format:"%m-%Y"} However that does not work in my .php code …

I am using VS2010 and SQL Server 2005. I have a query to search between dates. Depending on which date I select on the datetimepicker I get no results or limited results, but mostly not all the dates between the two dates I specify. For example, if i select 10/9/2010 …

I am assuming I will use the date function but I want to get the day that is the 3rd wednesday of the month. My site has dates for meetings and they are always the 3rd wed of the month. I like to show the next 3 meeting dates. Could …

need to write the below javascript function in php..please help [CODE]myStartDate = new Date('April 1, '+curYear+' 1:59:59');[/CODE]

Hello, I have a jQuery datpicker setup like this: [CODE] <script type="text/javascript"> $(function() { $('input').filter('#startPicker').datepick({ minDate: new Date(2010, 11, 20), maxDate: new Date(2010, 11, 27), multiSelect: 999, altField: '#date' }); }); </script> [/CODE] is it possible to show the number of dates the user clicks on in the altfield, or …

Need help counting the # of days between two dates (ex: 1/2/10 and 1/24/10) Better yet, the # of hours would be a great alternative.

Hi All I am trying to add a no under 18's feature to my register page. I have got a simple function which uses the year of birth but I am not sure what to do for the day and month. Here is the code. If someone could help me …

Ok, so I will do my best at explaining this... I have set up a database of our company's Parts Ordered forms. I have created a php form that allows users to inject new POs into the database. Which works successfully. I am working on the search form to allow …

I am currently wanting to know how to find out two different dates from a list of dates for each customer. I can find out the first date for each customer but I need to know their 6 month and 1 year visit. But the problem is not all the …

Hi all, bit of a c++ newbie and hoping you might be able to help me with a problem. I'm trying to calculate the elapsed time between two dates using difftime, however I keep getting an elapsed time of 0. Can anyone see where I'm going wrong? Any help greatfully …

I was just wondering if there was a more optimal way to add dates to mysql if I had a drop down for each field. This is the code I use to format the dates [CODE]$date_hired = format_date($_POST['month_datehired'], trim($_POST['date_datehired']), $_POST['year_datehired']); //I have 3 dropdowns in my form, 1 for months, …

I want to retrieve dates between two dates the user has specified e.g. say the user enters the dates 01/10/2010 amd 05/10/2010 i want to be able to get the dates inbetween the dates entered by the user e.g. 02/10, 03/10.... What possible way is there to do it? Thanks …

hi, How to find Date Differance in c#. in vs2008. thanks in advance. jack

Hello everyone, i'm using jQuery datepicker with the weekselector like this: [CODE]$(function() { $('#startPicker').datepick({ renderer: $.datepick.weekOfYearRenderer, firstDay: 1, showOtherMonths: true, rangeSelect: true, minDate: '+1d', onShow: $.datepick.selectWeek } ); });[/CODE] what i would like to achieve is to only show weeknumbers, i need a weekselection only, does anyone know how to, …

Hello, I'm working on a project in C to practice before I take a class this fall that requires C. I decided on making a task list. First, I'm starting with a cli interface, and then I hope to move it to GTK+ since that would look better and I …

Hello everyone, In attachment File Have ziped file for Ajax Datepicker. The Code is working but i have some problem. if i want to use it with php, how can i know where is the $_POST name . Code : [CODE]<div id="widget"> <div id="widgetField" style="width: 290px; height: 26px"> <span>28 July, …