A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Running & Setting Up Queries Forum Tools Search this Forum Feed Icon
  Thread Reverse Sort Order / Thread Starter Last Post Replies Views
date format - datediff - Not working by buckpeace
I have a date format of 19850617, I need it to be 06/17/1985. The 19850617 is in text format and when I run a query to change it, it comes out as 105 -...
April 13th, 2007 01:15 AM
by John Spencer Go to last post
4 103
date format as part of concatenation by martyn
I want a new field to be created call Update for use in a report as abreviation of data Update: Steps!Updater & " " & Steps!Updated to give this format -- ...
May 25th, 2006 12:47 PM
by John Spencer Go to last post
2 63
Date format autoconverting to time by Can Of Worms
Access 2003 I have been running into an issue in the past few days that has been puzzling me, and I have not been able to find a reason for it. If I use VBA...
June 15th, 2007 09:02 PM
by Can Of Worms Go to last post
4 101
date format conflict by steve mckenna
I have a database that searches for documents by date of document and date received. If the exact date is not know I have set up a parameter query that allows...
July 13th, 2004 12:42 PM
by Steve McKenna Go to last post
5 222
Date Format Conversion by Mario
I have a list of clients in an Access database. Each client has a meeting that takes place on a specific day of a given month each year: e.g., "second Monday...
July 8th, 2004 02:41 AM
by Ken Snell Go to last post
7 198
date format conversion by buckpeace
I have a date of 1/5/2006, it needs to be 01/05/2006. I ma having a hard time getting hte leading 0's where needed. Appreciate any help! -- Buck
December 19th, 2007 05:18 PM
by Michel Walsh Go to last post
1 72
Date Format Conversion by Paputxi
In a query (hopefully), how do I convert a date/time value from "MM/DD/YY HH:MM:SS AM/PM" format to just "MM/DD/YY", i.e., drop the hours, mins and secs? ...
June 7th, 2006 02:04 AM
by Douglas J. Steele Go to last post
3 142
Date Format HELP by John Vercelletto
I know this is probably and easy one, I have done it before, but blanking out now. I have a date/time field (DateShipped) and I am creating a query from the...
July 12th, 2004 03:50 AM
by Van T. Dinh Go to last post
3 116
Date format if date is blank by jwr
In queries, if date field is blank, what criteria do I type so that only information with a valid date will print? thank you, JR
August 25th, 2005 02:01 PM
by Rick B Go to last post
4 84
Date format in a make table query by PhilM[_2_]
Hi, I have a working make table query that has a date as one of the fields. Is there any way I can force the query to format the date as dd/mm/yyyy in the new...
January 10th, 2009 12:26 AM
by John W. Vinson Go to last post
2 60
Date Format in a Query by K. Hulse
I am linked to READ ONLY tables that have the dates in the following formats, (a mixture of lower case and upper case): Jan-05 and JAN-06 If I run the query...
March 2nd, 2006 05:02 AM
by Duane Hookom Go to last post
3 65
Date Format in a Query by Peter
Hi again all... I have an issue with the date format in a query. The query is based on fieled, "Date created", from a table whoes format is "Long Date"...
June 4th, 2009 02:25 PM
by Peter Go to last post
5 104
Date format in crosstab query by Matt
I have a crosstab query where the value crosstab outputs a date. I want it to output in medium date format but it always gives the general date format. Every...
September 12th, 2005 07:32 AM
by Duane Hookom Go to last post
3 236
DATE FORMAT in crosstab query by Mary
Access table with fields: Customer, Cust PN, Ship Date, Qty, Price I imported an excel file into this access table. The date field in access is set at short...
February 18th, 2005 04:31 PM
by Duane Hookom Go to last post
2 348
Date format in query by Sandy
Hello - I have a date column that is populated with "Now()" (Date and time). I want to write a query that Deletes all records where the date is today's date...
February 23rd, 2006 07:25 PM
by Marshall Barton Go to last post
1 81
Date format in query export. by Hansplay
I am exporting a query to a .csv file. In a Date field I formatted as so: FormattedActivityDate: Format(,"yyyy/mm/dd") The date in the .csv file shows up in...
February 10th, 2010 03:14 PM
by Hansplay Go to last post
4 159
Date format in SQL by Dylan Moran
I want to create a from which takes the user input date from a text box, assigns it to a variable (using VBA) and then uses that variable to from part of my...
May 19th, 2005 04:18 PM
by Marshall Barton Go to last post
3 95
Date Format In Table Is Not Working by R Tanner
Hi, I have a field in a table in an access 2007 database. The field is set to data type date/time and format medium date. I have a form that has a textbox...
May 1st, 2009 06:13 PM
by [email protected] Go to last post
3 84
Date format in update query by John
Hi How can I ensure that date is always assigned in dd/mm/yyyy format to a date filed, in an update query? Thanks Regards
June 23rd, 2006 07:11 AM
by Allen Browne Go to last post
3 74
date format inconsistent by Starry
Hi Despite reading all I can I cannot seem to work around this. My query is flipping ambiguous dates to US format. If it is passed a date of say 23/08/2009...
May 14th, 2007 04:05 PM
by Starry Go to last post
3 84
Post New Thread


Display Options
Showing threads 9941 to 9960 of 43289
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:08 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.