473,385 Members | 1,337 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

Changing the format of Date input in Access Query fro calculation

My query requires a date input however when this date is outputted, it comes in a format DD/MM/YYYY however the display format is still text and not a date. i want an extension of the query (calculation purpose) using this field however it is not possible using this format.

The input request is as follows:
PayDate: FormatDateTime([Enter Pay Date],0)
Feb 22 '12 #1
2 1535
Mihail
759 512MB
I think that a look to this article may help you.
http://bytes.com/topic/access/answer...ional-settings
Feb 23 '12 #2
NeoPa
32,556 Expert Mod 16PB
I think what you need is to pass the value as-is (A date I presume) but use the Format property of the control or field to display it as required, rather than a function which returns a string. Both ways show the date correctly formatted, but only the former allows the data to be treated as a date going forward.
Feb 24 '12 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: abcabcabc | last post by:
I write an application which can let user define own date format to input, How to convert the date string to date value with end-user defined date format? Example, User Defined Date Format as...
1
by: igendreau | last post by:
Hopefully this is a simple fix. I'm writing a select query, and I want the user to enter a start date when the query opens, so I have this expression: StartDate: So I open the query, it...
3
by: Jim in Arizona | last post by:
I have a gridview that's being populated from an access db query. The problem I'm having is that the date/time fields in access that are populating the gridview are showing both date and time, when...
2
by: ankz | last post by:
Hi Friends I am stuck at only one problem in the access database. I have got the label on the form and I want that label to be run by a query. I have created query where i have got only 2...
0
by: astersathya | last post by:
Date Format in MS Access using a query Hi I want to alter the existing column's format using the alter query. The issue I am facing is I want to set the default date format of an existing...
5
mgpsivan
by: mgpsivan | last post by:
Hi, i have form in Asp.net(2003) in that i've to change the format of the date by the following statement Format(Date.Today, "dd/mm/yyyy") but when i give this code the month part displays as...
9
by: kathnicole | last post by:
hi there, I have a field called DateEnacted (data type :date/time) could anyone tell me how can i change the format to dd/mm/yyyy , when i enter values in the table, instead of mm/dd/yyyy? ...
8
by: MLH | last post by:
Sometimes it works and sometimes it crashes. If I want "Today is " & Date$ & "." to appear in a query field, why might it work sometimes and not others? Would I be better to call a FN? Say,...
15
by: OzNet | last post by:
I have a query (with calculated fields) in Access (2007) and the data changes depending on the dates and staff person selected. I need to produce a series of graphs based on the data in this query...
3
by: Anthony97 | last post by:
I'm trying to get a date that's is 7 days earlier than the current date, so when I run the query I will always have records that came in within the last week. Here's the section of the code I'm...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.