Date/Time in different languages
I have a facility in my program to set the date and time format
according to the user's preferences. To do so, I run this command:
_T("shell32.dll Control_RunDLL timedate.cpl"),
whichs presents a system dialog where the user can select anything
he needs. My problem: The dialog is always shown in the
operating system's language. But I'd like to show it in
other languages, too. Is this dialog available at all in other
languages? And if yes, how do I launch it?
I have a query with a 'date' column. In this column, I have dates from
7/27/2007 - 8/12/2007. When I sort the dates, it goes from 7/27 - 8/1. Then
it goes 8/10 - 8/12, and from 8/2 - 8-9. What can I do to get this thing to
The problem is that your dates are not dates, they are text strings.
Try adding a calculated column and then sorting by that column
Field: RealDate: DateValue([YourField] & "/2007")
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
&quo...Associate date format with account
I have a couple of English bank accounts and when I download data from them
to load into Money, it has a nasty habit of assuming that the dates were in
American format (MM/DD/YYYY) rather than English (DD/MM/YYYY).
Please allow this to be configured on the account if it differs from normal.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-ba...Figures to words
Can we convert figures like 5000 to words as Five Thousands in Excel by any
"jain_sanju" <email@example.com> schrieb im Newsbeitrag
> Can we convert figures like 5000 to words as Five Thousands in Excel
> Sanjay Jain
...Date parameters won't work on crosstab report
I have queries and reports that show our quotes by lead source. I use date
parameters to filter the "QuoteDate" range on which to report.
However this doesn't work on a crosstab query or a crosstab report.
My row heading is Lead Source (e.g. Yellow Pages, Recommendation, etc etc).
My column heading is Status (e.g. Booked, Lost, Pending etc)
The values of our quotes are displayed accordingly, no problem.
On a regular Select Query or a basic Report, the date filter works fine.
However, on a Crosstab Query, if I enter StartDate and EndDate (Date/Time)
in the Query/Parameters windo...Subtotal by date shows US format rather than other way round
I have a spreadsheet which has data subtotalled by date. My date format
is dd/mm/yyyy, but the subtotals show mm/dd/yyyy. When I look in
'format cell' it shows my format is dd/mm/yyy, but even still it shows
the other way around.
How do I fix this?
...Query to extract data on the basis of date
I have created a query to extract the details of data on the basis of
date in the table. The problem is the query is not giving the correct
details. Can you pls let me know how to solve this problem?
Thanks in Advance for the help!!!!
I'm sure you know exactly what result you want, based on your data, but keep
in mind that no one else has this benefit. You will need to explain in more
detail what your problem is, if you have any hope of getting your question
Is the date in your table stored in a Date/Time data type, or in a tex...Date Fields Comparison
I WILL LIKE TO COMPARE TWO DATE FIELDS IN A ROW AND SELECT THE CELL
WITH THE GREATEST NUMBER OF DAYS IN THE MONTH FOR THE ROW. WHA
FORMULA WILL ENABLE ME TO ACHIEVE THIS , PLEASE. THE ROW IN QUESTIO
IS ABOUT 5000
SEE EXAMPLE BELOW.
DATE 1 DATE 2 RESULT EXPECTED
08/04/04 09/05/04 08/04/04
01/04/04 30/04/04 30/04/0
Message posted from http://www.ExcelForum.com
first: please turn-off your CAPS Lock: Makes it difficult to read
For your question: Why did you choose 08/04/04 in the first row? Date 2
has 9 days?
Frank...Converting dates to fiscal quarters
Is there a way to easily convert a date to a fiscal quarter
Eg 1/1/03 converted to Q1-2003, 12/7/98 to Q4-199
Thanks in advance for your respons
One way with the date in A1
="Q"&INT((MONTH(A1)+2)/3)&" - "&TEXT(YEAR(A1),"@")
"James" <firstname.lastname@example.org> wrote in message
> Is there a way to easily convert a date to a fiscal quarter?
> Eg 1/1/03 converted to Q1-2003, 12/7/98 to Q4-1998
> Thanks in advance for your res...No days, only dates
When I view the calendar in Week mode it displays the dates, but not the
days of the week. Of course, in time you will get used to it and don't need
to count round from Monday to Sunday, but it would be nice if the day was
next to the date on top of each box. Is there an option for that?
That is a long date format setting. If you use days in the long date, you'll
see them on the calendar.
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Outlook Tips by email:
dailytips-...How do I put tally counts in Excel?
Just a tad more detail wouldn't go amiss here.
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
It's easier to beg forgiveness than ask permission :-)
"KK" <KK@discussions.microsoft.com> wrote in message
Care to explain in the body of the message what ...Problem Date Formatting
I'm having a problem changing the formatting of a cell to
a date format. I have changed the format of the cell to
date... however, when a date is entered into the cell an
= apperars in front of it in the formula bar and the
result in the cell is 00-01-00.
Can anyone suggest what is going on?
Thanks in advance
Make sure that in the tools options transition that lotus
1-2-3 has not been checked.
What is happening is you are dividing the day by the month
by the year which will evaluate as something less than
one, and as the Excel Calendar starts from Jan 1st 1900 a
valu...i want to select a date in calander
I want to select a date in excel 2007 that date has to appeare in desired cell
this how is possible
EggHeadCafe - Software Developer Portal of Choice
C# MSMQ - Send and Receive XML
Check it here
On Nov 19, 10:25=A0am, jai krishnan wrote:
> I want to select a date in excel 2007 that date has to appeare in desired=
> this how is possible
> EggHeadCafe - Software Developer Portal of Choice
> C# MSMQ -...Tracking "Date Last Saved"
I am trying to show on the page (footer would be ok) the
date that a spreadsheet was last modified. The footer
only allows input of the current date and time. I want
something that shows when someone made changes to a
spreadsheet, not just viewed it. Basically need the info
in the "Properties" section to show up on the page. Any
if you want to insert the last save date in your header/footer insert
the following code in your workbook module
Private Sub Workbook_BeforePrint(Cancel As Boolean)
Dim wkSht As Worksheet
For Each wkSht In Me.Worksheets
I am looking for some advice on how to tackle querying some data.
I have two tables, table one with around 10,000 records per month and
columns that give me (for each record) a start date, start time, end date and
Table two details a percentage for each hour and day of the week (so 24
hours * 7 days = 168 records). This has three columns, the day of the week
(Mon to Sun), the hour (00:00 to 23:00) and a percentage.
What I want to do is sum the total of the percentage column in table 2 where
the day of the week and the hour of the week fall within the st...How can I figure square footage for 2 or 3 numbers in a row?
I need to figure square footage of 2 dimensions, height, width, , leaving out
a thrid number in the same cell, then multiply by a separate number. Any way
to do that?
Post a sample of your dimensions.
You might be able to do that with LEFT(), MID() and RIGHT()...? A looong
shot guess would be something like this:
Where your 3 numbers in F1 are 2x5x10, and H1 has the number 8, which you
want to multiply by.
Falls apart with two-digit dimensions or a combo of one and two!
"Sandi" <Sandi@disc...Subreport link by Date field
Hello, I have an Access 2003 report with a subreport. The main report has a
column for customerID and Date, I want the subreport to show any records from
another table that occurs after the Date on the main record. Can I use the
Link Child Field and Link Master Field for this? I know I can put
"CustomerID;Date" in these fields but that would give me results that have an
exact date match.
Try using CustomerID in the links and Date criteria from main form in query
for the sub.
Build a little, test a little.
> Hello, ...Date format in Receipts
My boss wants to add the Due Date on each receipt that uses Account as
tender. I created the variable on XML code using:
<SET name="DueDate" type="vbDate"> Transaction.Date + 20 </SET>
And print it with:
<CONDITION> (Tender.Descriptor.TenderType = tenderAccount)</CONDITION>
<ROW> "Due Date|" DueDate </ROW>
This works, but the DueDate is printed as a number. How can I change its
format to MM/DD/YYYY. I tried using all VB Date function, but no one worked.
Please, hel...Change Date Format Within E-mail
While using the E-mail Template Manager, I notice the
date format that comes in from the database is 2005-01-
12T00:00:00-05:00. I'm assuming this is GMT format.
I would like to have this format modified to 12/01/2005.
Is this possible?
Please help ...
This option is not available currently out of the box.
San Francisco, CA
> While using the E-mail Template Manager, I notice the
> date format that comes in from the database is 2005-01-
> 12T00:00:00-05:00. I'm assuming this is GMT f...Add a date to a form
I am wanting to add a CreateDate to a form which enters the date from the
computer system but doesn't update the next day.
Any helpers please!
I'm assuming you mean you want the CreateDate to be on a field in a table.
Simply putting a date on a form doesn't buy you much...
Set the field's DefaultValue to Date() (assuming all you want is the date),
or Now() (if you want both date and time). Whenever a new row is added to
the table, the field will pick up the default value. The Default Value will
have no effect on existing rows.
Doug Steele, Microso...Timer, Tally, and Count
I am trying to expiriment with using excel to design and layout a
factory. I don't know if I can get Excel to do what I want but here
I would like to designate a cell as a station in a factory set a
certain time that station uses to "make a product" then have that cell
"send" its part to another cell named travel for an amount of time then
to the next station in the factory. for ex.
Cell A1 is Welding, welding takes 5hrs to do a job and then it sends
its parts to Cell B1 is travel, travel takes 5min to get to the next
step which is Cell C1 Paint, Paint takes ...Removal Date
Please help for the following condition:
1. I have one sheet "A" which contain of database, the field structure as
Field A = Date
Field B = SN
Filed C ...
I have a lot of records, which can contains the same SN (Serial Number) but
with different Removal Date.
2. on the other worksheet...i create the following field
COL A = SN
COL B = First Removal Date
COL C = Second Removal Date.
COL D = Third Removal Date.
Please guide to which function i should use? As i use VLOOKUP, it will be go
the first occurance of the date removal...(the...Switch X & Y axis' when both data columns are dates (target/actual
I am plotting Target vs Actual completion dates for a project management
S-Curve, using Excel. Since both data columns are "dates", Excel wants to use
"dates" on the Value Axis (Y), while putting the Task #s on the X axis. How
do I switch axis' so that time runs horizontally on the X axis, with the Task
#s on the Y?
Chart menu > Source Data > Series tab: change what's in the edit boxes for X
You could try this utility:
Jon Peltier, Microsoft Excel MVP
Tutorials and Cust...Convert a Date to a Day
Is it possible to have a reference date in Cell A1 - say 19/04/2005 and
Return a value in Cell B1 - Tuesday ?. I've tried =DAY(A1) but it returns 19
"John" <email@example.com> wrote in message
> Is it possible to have a reference date in Cell A1 - say 19/04/2005 and
> Return a value in Cell B1 - Tuesday ?. I've tried =DAY(A1) but it returns
"Don Guillett" <don...Remove "Date: Yesterday" or "Date: Monday" from Outlook Inbox?
Outlook mail inbox now has headers that tell you what day the the email was
sent. I find this visually annoying. Each emailalready has the time and day
it was sent. I don't need the daily titles in the midst of the list of
emails. How do I make them go away?
I think you are talking about OL 2003 & the Arrange in Groups setting. Change
it in View, Arrange by, uncheck Show in Groups.
> Outlook mail inbox now has headers that tell you what day the the email was
> sent. I find this visually annoying. Each emailalready has the time and day