[date] Forum Topics

i need to know if there is a member whose enrollment date is earlier than a specified date. If this case, the specified date = $Monday [CODE] $Monday = 12-30-2009; $result = mysql_query("SELECT COUNT(*) FROM agents WHERE (sponsor = '$parent') and (lft between $leftlft AND $leftrgt) and (enrollment_date >= '$Monday')"); …

The code snippet below is the beginning of a script I've been working on. What I need to figure out is make sure that I can generate the corresponding day last year. The business logic is such that I am supposed to compare sales data from the last business day …

Background: I have a tool that grabs files from a network location based on the file name. There are various files, but the names are all based on the creation date (report052209.txt). What i need to do is take the date selected from a datetimepicker and save a two digit …

[B]I want result as Not Available if value is null or 0000-00-00 or 1971-01-01[/B]Hi, this is a code , which I used for showing results from 3 tables. Lease_North is my main table. When I join with another 2 tables using Left, if there is not value exist in table …

I am trying to get my date that people enter into a form from mm/dd/yyyy to input it into the database. I can't seem to get this to work, I guess I only know enough to hang myself, what would someone use to get this to function properly? I've been …

This is a simple code-snippet that can be used to parse dates with javascript. It's setup to use European dates (dd.mm.yyyy | dd/mm/yyyy | dd,mm,yyyy), but it can easily be setup to use american dates as well (mm/dd/yyyy etc), to do so simply replace "$1" with "$2" and "$2" with …

I know it is as simple as it is, I've search around the internet and I came up with nothing. Maybe I don't know what to search for. Basically my datetimepicker format is set to year only. My string is "2009" I want the datetimepicker-year to set as the year …

I am developing a Lease Information Management System. This system is related with Land rent Contracts. Every contract have a Begining date and Expiry date. For example Begingin Date is: 01-08-06 And Expiry Date is : 31-07-16 I have store these 2 dates in DB. Payment will be given to …

I have having a bit of trouble with this assignment I have to do. The assignment is: [B]"Assuming that a year has 365 days, write a class named DayOfYear that takes an integer representing a day of the year and translates it to string consisting of the month followed by …

Hello everyone! I searched the site already to see if this question has been addressed already and found no results, but if it has then I appologize and if you can link me to that thread I'll refer to that to solve my problem. I am trying to save a …

im making a program that gives you the age of the person that enters there date of birth the code i got at the moment is: Private Sub Command1_Click() Dim age As String age = Month(Now) - Text4.Text If age < 0 Then age = 1 Else age = 0 …