Mm/yyyy

Jun 27, 2007

hey
i want to use the format mm/yyyy in my date field.
how i can do this ?

View Replies


ADVERTISEMENT

Convert Date To YYYY/MM/DD

Apr 1, 2008

how do i do this? i found an old thread concerning this but it must not apply either to vista or to the most recent version of office.

View 14 Replies View Related

Going From A Julian Date To Mm/dd/yyyy

Dec 22, 2005

This may be simple but I'm having a real issue with it. I've used

Format([Input Table]!Birth_Date,"yyyy") & Format(Format([Input Table]!Birth_Date,"y"),"000")

to go from a date to a julian but now I need to go from a 4 digit julian date to a mm/dd/yyyy.

For example ... Today is julian date 5356 "year 2005 and 356 days into the year" and I need to change this back to 12/22/2005.

How do you do this :confused: I would rather do it within the query than do any code.

View 4 Replies View Related

[Auto Number]+[(Current)MM-YYYY] As Key?

Mar 27, 2008

Hi all,

First post and hope that someone can help.

I need to create an auto generated key with this format.

[Auto Number]+[(Current)MM-YYYY]
[Auto Number] = 0000
[(Current)MM-YYYY] = Current Month + Year

Pls help.:(

View 14 Replies View Related

Change Text Yy.mm.dd To Date Dd/mm/yyyy

Sep 12, 2006

After having to take on the work of someone else and finding that the dates were stored as text in the format yy.mm.dd I would like to change it so it is dd/mm/yyyy and stored as a Date.
I was thinking about using an update query rather than go through 10000 odd records!

Any ideas?

View 2 Replies View Related

Dd/mm/yyyy In Date/time Format

Apr 5, 2007

Hi everyone

I have 2 date fields date1 and date2 , and i have date/time data type but what i want to be inputed is in dd/mm/yyyy and not mm/dd/yyyy, what do i need to do in accees both date fields properties to make sure it is in UK date format. thanx

I have played with the format and input mask but i am lost dont know what to do.

Thanx

View 5 Replies View Related

Short Date = Mm/dd/yyyy Not Dd/mm/yyy (Regional Settings= UK!)

Aug 22, 2006

Hi,

I have a huge problem!!!! Access seems to be picking up settings from somewhere which means that the Short date = mm/dd/yyyy and not dd/mm/yyy as set in the regional Settings!

Does anyone have any ideas why?!?!

Regards
H.

View 4 Replies View Related

Access Rookie - Calculating Difference Between Dates In Format Mm/dd/yyyy Hh:mm

Jan 24, 2008

Hi, I am a longtime Excel user, and am now migrating some work to Access.

I have 2 fields dealing with dates in the format mm/dd/yyyy hh:mm, OPEN and CLOSE

I'd like to get the difference between the two in hours, but I have no idea how or where to do this in Access. I'm assuming it is put into the queries, but it would be easier if I could just put it in the table.

Here is an example
1/1/2008 1:00 1/2/2008 2:00
I want the result to be "25"

Thanks in advance!

View 9 Replies View Related

Queries :: Converting Mmmm Yyyy To Including All Dates In That Range In Query

Oct 14, 2014

My table has many records for each month. I am creating a report that will display only the records in one month of a year. I have been able to create a form that gives the user the choice of the Month and Year for which to create the report. The code I am using to create the combo box is:

Code:
SELECT DISTINCT Month([QTDate]) AS MoNum, Format([QTDate],"mmmm yyyy") AS MoName
FROM MainTBL
ORDER BY Month([QTDate]);

What I need to do now is create the query for the report that displays all records for the chosen month and year. If I simply reference the combo box, all it shows is mmmm yyyy and the days are missing so the query doesn't work. What do I need to do to create the query so it displays all days within the month and date selected?

View 6 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved