Can I change the calendar year beginning date?
Our fiscal year runs July 1 thru June 30 of each year. I need to track
attendance, gas cards, etc for monthly reports. I have a HUGE table with a
gazillion queries and reports for each one. I need one report to reflect
quarterly output for our fiscal year as stated above. Can I make this report
Create a query to use as the source for your report.
In query design, type this into the Field row:
FinYear: DateAdd("m", -6, [InvoiceDate])
replacing InvoiceDate with the name of your date field.
This yields 2007 for all dates in the 2007/2008 financial year...Date Formatting when Concantenating
I have a simple question. I have a cell that has date that looks lik
When I use the concantenate feature my date looks like this:
I tried to format the call every which way - but I cannot get it t
look the original.
Feeling really silly for even asking.. thanks all for your help
Message posted from http://www.ExcelForum.com
="Today is "&TEXT(TODAY(),"mm/dd/yyyy hh:mm")
Norman Harker MVP (Excel)
"bleu808 >" <<bleu808.189yij...How OMPM Scanner (offscan) Filter by Access/Modified Date ?
I have problem to inventory excel files on very big file server, but I
believe there are so many documents we no longer need to maintain.
I want to skip files if the access date or modified date longer than 6
month, but don't see the OMPM providing feature about it.
I currently running OMPM since 2 weeks ago and running out of time for
reporting to my manager.
Please help me, this is my critical assignment.
...Show a date 30 days out
I have a feild that I would like to show what the date would be in 30 days
for a feild with a date in it [Sold Date].
Sold Date feild would be 1 Jan 07 so the feild would show 30 Days later 31
I did =[Sold date]+30 and it did not work
how about dateadd:
dateadd("d", 30, [Sold Date])
"KAnoe" <KAnoe@discussions.microsoft.com> wrote in message
>I have a feild that I would like to show what the date would be in 30 days
> for a feild with a date in it [Sold Date].
...Dates in fomula showing as whole number
I have a fomula in a cell that takes the name of a person (from cell 2B),
their License number (from another cell 2C)and the Date that License Expires
(From cell 2D). The expire date in "2D" is either the word "none" or a date
that that persons license needs to be renewed.
Those instructors with "None" come out in the calculated field fine, however
the ones with dates come back as whole numbers, Example 8/6/10 shows 40396.
any help will be appreciated
You need to change the format of that cell or column, highlight the cell or
the column, right click o...WM_QUERYENDSESSION and saving data through a worker thread
I have an application that uses a worker thread to save/load data.
I'm wondering what is the best reaction to WM_QUERYENDSESSION in my case.
I have to possible scenarios:
1. When WM_QUERYENDSESSION comes fire the thread and wait for it to end.
Only then return TRUE from WM_QUERYENDSESSION handler.
The problem is that I will get nusty dialog that my application "is not
2. When WM_QUERYENDSESSION comes fire the thread and return FALSE from the
handler. When thread is done force application to end. But this way I will
probably prevent Windows from closing,...Thanks Ken Wright but one more question RE saving data from circular references
Thanks heaps for that macro Ken Wright .
I have run it and it works.
However it loops forever. Can I set it up so that it could save dat
from a certain number of iterations?
Thanks again Michae
Message posted from http://www.ExcelForum.com
If you stayed within your thread and did not change the subject
Ken would see your reply as a reply to his reply and would see
it a lot faster than when you start a new thread. Ken would
probably see your post highlighted in RED. Also someone other
than Ken might have been able to help you. (not me I avoid
anything that hints of circul...Line Chart with dates in 5 day working week only
Trying to format a chart so that only the 5 working days of the week are
displayed on the x axis. The source data only has the five days (e.g.
05/09/2005 down to 09/09/2005 and then on to 12/09/2005 down to 16/09/2005
etc etc) So I have missed out the weekend dates.
When I create the line chart however, the weekend dates appear automatically
and just show no point on the chart, therefore there is a longer line between
Fridays and Mondays!!
Hope this makes sense.
Does anyone have any ideas on how to change this? I have tried looking at
Tools-options-chart and cannot seem to turn...O2003 New Toolbars Saved Where?
I have XP with O2003 on one computer. Just got a new computer with W7
and installed O2003. I copied over the "outcmd.dat" file and I can see
my data (e.g. views) so I know its using the correct "outcmd.dat"
However two custom toolbars I created are not shown nor are they in
the customized toolbar list. Are custom toolbars saved in a different
On Jul 24, 6:22=A0pm, srm <s...@primatech.com> wrote:
> I have XP with O2003 on one computer. Just got a new computer with W7
> and installed O2003. I copied over the "outcmd.dat" ...Keeping a table in a form editable and checking that fields are filled in before allowing a save
Firstly apologies if this is the incorrect forum but I was looking for
a general word forum and could not find one. Please point me to one if
I am trying to create a form where I want to specify what items need
to be filled in. (Review minutes from design reviews). I want to make
certain fields mandatory like the date, attendees and check list used
and want to block saving of the document with a warning until they are
filled in. Is there a way of doing this?
Also as a part of the review actions are filled in to a table.
depending on how many actions there are the table...Time performance Chart
I need to develop a chart that graphically depicts an employees start
time and end time each day. This chart would be a bar chart. The bar
chart would have days of the month along the bottom, and the side
would start at 00:00 at the bottom and end at 24:00 at the top. I
need to be able to enter an employees start time and end time and have
it charted along the bar. So if the employee started at 07:00 and
ended work at 18:00, the chart would show a colored bar that
corresponds to the start time and the end time. Also, if an employee
came back to work the chart would refl...How to get only the year in the date format in Access
How to get only the year in the date format
I.e in the table in need to display only year
E.g 2005 - should be display " 05" automatically
Custom format the cell as:
Please keep all correspondence within the NewsGroup, so all may benefit !
"yanu" <firstname.lastname@example.org> wrote in message
> How to get only the year in the date form...Problems opening/saving attachments
I am unable to open or save any .rtf file attachments - this started
happening today, previously there were no problems with .rtf files.
When I try to open such an attachment I get this message:
Can't create file: xyz.rtf
Right click the folder you want to create the file in, and then click
Properties on the shortcut menu to check your permissions for the folder.
What folder is this? I am trying to open the attachment not creat the file!
Also, when I try to send an rtf file as an attachment, in the email message
the file does not show in the attachments section but the receipient
actu...Copying recordset multiple times using copyfromrecordset
We recently caught this issue but found out after research, that this has
been occuring all year. This code worked in the past, but I am not sure if
there was an Excel update that occurred which changed the behavior of the
script. What we are trying to do is to have a recordset pasted twice into two
seperate worksheets. It is pasting without issue in the first
copyfromrecordset, but then it skips over the second paste (even when
stepping through the code). I know that it is not the worksheet we are
copying into because I can reverse the 'first paste/second paste' (see lab...date/time formatting
I download a csv report from a web based program. Everything works great
but the date comes through as "Jul 21 2009 1:51pm". I do not need the time
in my report. I have tried reformatting the cells, tried to copy to a new
file with the cells already formatted to "7/21/09", opening the cell format
using the F2 key and deleting the time (time will still not be formatted
correctly). The only way I get get just the time is to retype every cell.
What am I doing wrong?
I am using Excel 2002 SP3
When data is downloaded from the web, a lot of "other&quo...Saving address to replyed emails
IN outlook express I could automatically save the email
address when I replyed to an email.
I want to be able to do this in outlook 2002
Can some please help
Not possible. You will need to right click on the address and select to Add
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact.
Having searched the archives,
Garth <email@example.com> typed:
| IN outlook express I could automatically save the email
| address when I replyed to an email.
| I want to be able to do this in outlook 2002
| Can some please help
...Outlook saves image attachment as bitmap
I have Outlook 2003 running on Windows XP.
When I save an image attachments, it only allows me to save it as bitmap.
Before, it used to let me choose between bitmap & jpeg.
I found an article on Microsoft's website, but it only pertains to Internet
Explorer (http://support.microsoft.com/?kbid=810978#appliesto). I did it
anyways, but it didn't correct my problem.
Thanx in advance,
...M2004 Won't Save Customized Toolbars / Home Page
Unable to find anything in archives or the UFAQ on this...
My Money 2004 file recently stopped saving customized toolbars / home
page. Any changes I make don't "stick".
I've used super salvage, which supposedly found and corrected some
errors, but the problem persists.
Try this (and it is in the UFAQ under a less specific topic at
http://umpmfaq.info/faqdb.php?q=153). Stop Money Express. Change your
toolbar stuff. Exit Money. Restart Money. Restart Money Express.
"Sock" <firstname.lastname@example.org> wrote in message
news:8205f05b.04101407...Email Text Dissappears when Save
When we save email messages (as a draft) the text dissappears, even when th I
use my administrator account. Anybody have any idea what that is happening.
...Prevent users from saving music and pictures to their hard drives without folder redirection?
Hi there. I'm wondering if there is a way via GPO or anything else to
prevent users from saving music and pictures to their local hard
drives without using any type of profile or folder redirection.
...Saving MY Calendar into "Publication-Calendar"
My problem is that I have to make a certain type of calendar in every month. It would save lots of time forme if I could find a way that I could save my "calendar setting" and also be able to apply the new month's settings. There is any way that I could save my "home-made" calendar into "Publications-Calendar" and call it up just like the other calendars? Thanks.
If you have repeating items you just use the Merge for those items every
"If you don't know where you are going,
any road will take you there!"
I do not understand ho...Time Conversion
I need help in converting time. I am using data from a time clock which
currently formats time as 1.5. When I input this data into a cell how can I
have it formated to read 1 hour and 30 minutes (1:30)
What you could do in an adjacent row or column is format
them as Time and then using a formula, divide the input
time by 24(hours in a day).
>I need help in converting time. I am using data from a
time clock which
>currently formats time as 1.5. When I input this data
into a cell how can I
>have it formated to read 1 hour and 30 minut...Copy/paste range of rows between 2 dates...
Hi! I have a sheet called data which act as a database. The column A has
the dates. In order to create customized chart in a userform, for
different range of data(i.e from column D, G and M...), I'd like to
select a range of rows that are between 2 dates and create the charts
accordingly. Or copy to range to another sheet and then create the
charts. I am not so advanced in VBA and any help would be greatly
** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***
I have four fields on a form to show time. I want a seprate "Total" field to
add the time between the first two fields and then add the time between the
second two fields. Like this:
In LunchOut LunchIn Out
6:00am 12:00pm 12:30pm 4:30pm
The first four fields are stored as medium times. Can someone let me know
how to do this?
Message posted via AccessMonster.com
"ladybug via AccessMonster.com&quo...time formats #3
I have an Excel sheet with a long list of times spent on various projects.
The times should all be in minutes and seconds. The first time reads 2:29
and I know that is accurate, for 2 min, 29 seconds. In the formula bar, it
reads, 2:29:00 AM. Another...the cell displays 0:40 and I know that is
right, for 40 seconds. But in the formula bar, I see 12:40:00 AM
I want numbers, but apparently I am looking at times.
I tried changing the format. When I check the format for 2:29, it comes up
Custom and says it is hh:mm, not mm:ss. I tried changing it to mm:ss, but
that changes the displa...