[date] Forum Topics

Hi everybody i am new to vb.net programing and i am developing gym application and i need help in coding in a form i an giving the joining date of a customer and with membership duration and the thing i need is if select 30days membership then expiry date to …

im sending jquery date value and database cannot update the current format so i need php date conversion pls anyone suggest me

HOw can i convert the String "2012-07-30" to Date object with same format 2012-07-30 which is date not a string. I've tried but i get the result in string. plz help

I have a question about a better way to do this as what I've written seems clunky. I'm trying to generate 2 variables here that will be used as the date in a BETWEEN clause in MySQL. In order to get the proper construction (YYYYMMDD) I am converting to a …

Hello, I have a bit of challenge that I’m wondering if I can solve by SQL. My source table (thinned out) holds the following two columns: TASK_NAME [VarChar], DUE_DATE [Date] My end state is a list (will be a JQM list element) that will list out every task under headings …

Good day Gentl'men! I just need a little help for date manipulation.here is the criteria.. I have **two date picker, dtfrom.value & dt2.value, and a variable called "viewtype".. ** **if viewtype="monthly"**, I want to create a listview column base on fromdate.value & todate.value..Example, if **fromdate.value="12/24/2012" and to.value="06/31/2013"**, I want to …

Hi, I have a table with a timedate collumn. I want to get the text of the article and its creation date, than to output them on my page. How can I just get only the date value from a query or php script manupulation?

I know little PHP, but even less MySQL, and my host doesn't allow remote database connections (for example, from Dreamweaver), so in addition to being confusing to me, database management is impractical. Is there any way to put a timestamp on an article automatically, without resorting to MySQL tables?

Programming just for fun.

I want to validate time format by putting time picker on my form, then i search for it in Internet and i found it [here](http://trentrichardson.com/examples/timepicker/). I follow the steps, but it is did't work. In my page i just want to receipt time (hh:mm). i need it to validate the …

Im having a issue with comparing dates below is the code. it shows all rows even dates that have passed todays date. The Date field is set as date in sql. <?php $con = mysql_connect("localhost","myusername","mypassword"); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("mydatabase", $con); $todays_date = date("Y-m-d"); …

Hi, I am trying to generate a grid with days of the month in 1st row (i.e 1| 2 | 3 | 4 | till days in the selected month) and category of rooms from a database on 1st column. This is to check the status of the room booked. …

Hello, I am making a php comment box (without sql with a file where i post the comments) i'd like that the the time that the comment was posted be written along with the name of the person, but it gives me the current time, here is my php code. …

I've just started working with PHP, and one of the first things I want to do is add a timestamp to my article template in Dreamweaver, so that each article I post automatically has the post date. How would one go about doing this?

i have a table with day_date and price each record is displayed as below: Day_date Price Allotment 2012-05-20 500 2 2012-05-21 500 2 2012-05-22 500 2 2012-05-23 600 4 2012-05-24 600 4 2012-05-25 500 7 2012-05-26 500 7 2012-05-27 700 2 2012-05-28 700 2 what i want to do is …

Time and Date reset in win 7, every day it happen some time when i restart the system...i replace a new cmos battery but it won't help..

Hi, When a user registers on my site there status is 0 (not active) ... meaning they not activated there account via email. When they register i also store the DATETIME they registered, i store it in MySQL using MySQL DATETIME and using `NOW()` in my INSERT query on registration. …

Hi everyone! This is the code that I have made, however, when I enter a date for example if I type : 12/12/2012 then the date for tomorrow displays a list of dates. I am unsure how to get it to only display the date of tomorrow. #include <stdio.h> int …

Hello my fellow daniwebbers, I have yet another question. I have a date, which is pulled from a database, that I need to convert to another form of that date. Example. Date1: 1/2/2001 Date2: 01/02/2001 What i am wanting to do is turn the current date format into two digit …

hi, i have three text boxes tb1 has timeIn tb2 has TimeOut and i have a Button which shows the time duration between them i have used time diffrence method bt it is unable to calculate the duration it only gives the difference which create problem when time is greater …

Hi, I have this textbox that has been inputted by date in the format of MMM-yy using a datetimepicker. TEXTBOX Jan-11 Now I need to get the exact date on the textbox to be inserted in a string. string1 = Cdate(txtbox1.text.trim) but in this code, the inputted text on the …

Hey everyone, I know that there are hundreds of articles online about this same error, but I have been going at this for almost 2 days and it's time I just started a thread of my own. In my application, I have a textbox that has a CalendarExtender hooked up …

Hi Guys Im a newbie and a somewhat beginner in PHP Here is my problem I want to insert this date format - DATE_FORMAT(news.updated, '%%M %%e, %%Y') AS formatted FROM news into this already existing sql statement - $sql = "SELECT * FROM authors aut, news new WHERE aut.aurthor_id=new.arthor_id AND …

Just a quick snippet for beginners

Hey guys im trying to make a user form for my HTML page which asks the User to input a question and by clicking the Submit button I want the page to display the Text (Question Inputted) and the date that the user actually asked the question. This is how …

I want to select records from my table which have a date which is older than 200 days. The following code calculates that date and displays it on the page as '2011-08-10': [CODE] $todayDate = date("Y-m-d");// current date echo "Today: ".$todayDate."<br>"; //Subtract 200 days from today $rptdate = strtotime(date("Y-m-d", strtotime($todayDate)) …

In an XSLT file, I am calling a function to a javascript file (.ascx) and trying to pass parameters. One parameter is a Date() object. The only way I've found to successfully pass it is to pass it as a string. Here's the code from the XSLT file. [CODE]<script> grouping("<xsl:value-of …

hi want to know how read date from a file and take the data into a 2D array and again convert it in 1D array and covert the data format like 15-02-2012 or 15 02 2012 or 15s02s2012 into 15/02/2012 format and write it to other file

Im creating a project where the a blog can be submitted, the date is stored in the database as dd/mm/yy, however im using LINQ to SQL to get the date as well as other information, the problem comes when i want to display the date in a particular layout (similar …

In my database I have a datediscontinued. When someone runs a a report they select a start date (FORM.StartDate) and an end date (FORM.EndDate). I need to find the records where date discontinued is between the start and end date. If the start date is NEQ to the end date …