Running & Setting Up Queries - Page 497

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Thread / Thread Starter	Last Post	Replies	Views
date format by Shashi Kiran how do I ensure the date be stored in one format without any dependance of the regional settings of the client	July 7th, 2004 07:45 AM by Allen Browne	2	93
Date Format by Dan @BCBS This is an extension of Subject "Two PCs Diff Results" I'm trying to add this code to the below code just before the FROM: "\#mm\/dd\/yyyy\#") AS DueDate,...	May 31st, 2007 05:02 PM by Ofer Cohen	5	54
Date Format by Jim I am working with a government database that has a number field that contains date information formatted to read 20080623. I am trying to get the difference... ( 1 2)	June 29th, 2008 02:57 PM by Jeff Boyce	14	278
Date Format by me Hello, I cannot select records of a given day: SELECT DISTINCT , COUNT() AS Y FROM WHERE (Format(, 'Short Date') = ?) GROUP BY ; Parameter value...	September 3rd, 2008 03:00 PM by John Spencer	2	84
Date format by Peter Kinsman I am in the UK, so my native date format is dd/mm/yy. I have a query that selects transactions by date, so I normally use TranDate = # & Format(FormDate,...	January 12th, 2009 10:02 AM by Stefan Hoffmann	1	74
Date format by Chris I know how to use the date format to display the numeric value of months (1-12) but I would like to display the numeric value for 36 months (1-36). Does...	March 10th, 2009 04:28 PM by fredg	3	85
Date Format by Jim I am trying to build a query that shows all work scheduled to start prior to today. The "Scheduled Start Date" field is a 9 character NUMBER field where the...	March 24th, 2009 11:50 PM by John Spencer	3	119
Date format by Chi Hi Would you show me how I can convert 32 days to month and days? Ex: 32 days will be one month and 2 days. Thanks Chi	April 24th, 2009 10:32 PM by KARL DEWEY	3	87
date format by LG If I am bringing in a txt file that is , and " delimited, how do I change the format of the dates? Example the dates come in as 20080229, normally in excel...	October 5th, 2009 06:59 PM by LG	6	112
Date Format by Chris Here at my shop we use peoplesoft and peoplesoft uses julian dates that look like this: 107040. My question is if someone gave me a date in the format of...	February 23rd, 2007 03:36 PM by Chris	6	118
date format by Jean-Paul De Winter Hi, I have a table with a field called "Datum" Here the date of records are stored in format DD/MM/YYYY In my code I wrote: Dim Starten as Date Dim SQL as...	January 30th, 2007 10:21 PM by Jean-Paul De Winter	2	53
Date Format by Aurora I am using Access 2000 In a query, I have the following formula DateSSigned: IIf( Is Null," ",Date()) to insert the current date when a signature is...	September 21st, 2004 03:55 PM by Ken Snell [MVP]	1	337
date format by Leslie Isaacs Hello All I have imported some data that has a date field in the format yyyymmdd. The rest of my database has dates as ddmmyyyy, so I don't want to change...	October 13th, 2004 11:35 AM by Jeff Boyce	1	84
Date Format by Krish One of the fields in an attached table, the year and month is written as yy-mm.(99-01,99-02,99-3....03-04,03-05,03-06....04-07,04-08,04-09). I want to convert...	October 13th, 2004 08:49 PM by JL	1	85
Date format by Mark Hello all, I have a table with a date/time (together) field. In a query I'm trying to group on date and count another field. What I want the query to show...	May 11th, 2005 02:11 AM by Mark	2	97
Date Format by Jologs Hi: strSQL = "INSERT INTO tblLog (Username,logDate) VALUES ('" & txtUserName & "', #" & txtLogDate & "#);" I used the above code to update my tblLog. my...	September 3rd, 2005 06:34 AM by Jologs	2	85
Date Format by Dan @BCBS Is there a way to remove the seconds from a "general date format" in a text box???..	January 25th, 2006 01:17 PM by Dan @BCBS	5	94
Date format by Tom Hi all, In my table I have field : OrderDate which is a date. on a form I have a comboBox which has to be populate with only the year from OrderDate. How do I...	June 24th, 2006 07:08 PM by Tom	7	114
Date Format by Vinnie via AccessMonster.com Hi, I have a query that reads in a date field from a table. I've put 'Month: Format(,"mmm-yy"); around the data, as I'm calculating a monthly sum. But when...	August 14th, 2006 01:55 PM by Klatuu	2	89
Date format by Scott_Brasted via AccessMonster.com Greetings, I am putting thisinquery because i think I will have to use a query to get my result. I need to export an Accwss 2000 table to mySQL. The table has...	January 23rd, 2010 12:41 PM by Scott_Brasted via AccessMonster.com	2	189

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed