Computer Support Forum

Use field value as the year in a date

Question: Use field value as the year in a date

I work with MS Access 2003.

I am creating a query to show all contracts set up in a certain year that have been cancelled in that specific year. This "Cancelled" field is not a yes/no field, but includes the date on which it has been cancelled (always starting 31/12/YYYY).

First, to show me the contracts set up in a certain year (say 2008) , i created a parameter under the "Contract Year" field, asking which year you want to see (in this case 2008).

I wish to add a criteria that then shows cancelled contracts at the end of that specific year, so 31/12/2008. So whether it is "2008" or another year is dependent on the value in the "Contract Year" field.

I tried the following as criteria for the Column "Cancelled":

#31/12/[Contract Year]#

to try and have it take the year mentioned in that field.
But it doesn't work. Access sees is as a second parameter, instead of a field name.
I tried adding LIKE to it and the &-sign, still no luck.

Is it possible to use a field name in a date criteria and if so, how could i do it?

Thank you very much in advance for your help.

More replies
Relevance 100%
Preferred Solution: Use field value as the year in a date

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

Relevance 97.17%

Looking at the Last Modified Date in Windows File Explorer, the Year field shows the year 2036 on some files but not all. The Creation Date matches the Last Modified Date. This happens to folders and individual files.

I first noticed this when I did a fresh install of Windows 10 Anniversary Update. Does anybody have an idea what is causing this. Any help would be appreciated.

Attached: a snipped image of Windows File Explorer showing the problem

Answer:Date Last Modified year field is set to the year 2036 on some files

Hello wguimb,

Looks like you're from the future. LOL

Double check to see if your system date may be set incorrectly somehow.

https://www.tenforums.com/tutorials/6...dows-10-a.html

9 more replies
Relevance 74.62%

Filename: SysInfo.exe
Full Path: c:\Users\JIMBO\AppData\Local\Microsoft\Windows\INetCache\IE\RBAGCWGH\SysInfo.exe

____________________________

____________________________
Developers
Not Available

Version
1.0.0.2

Identified
6/27/2016 at 5:17:31 PM

Last Used
Not Available

Startup Item
No
____________________________
Many Users
Thousands of users in the Norton Community have used this file.

Mature
This file was released 4 years 8 months ago.

Good
Norton has given this file a good rating.
____________________________
Source File:
sysinfo.exe

____________________________
File Thumbprint - SHA:
8243b4ea661b060fe8cf4babc11ab5f51eadd28a0c9d66303183e8eceace8234
File Thumbprint - MD5:
Not available
 

Answer:excel Today's date (year) - cell date (year

11 more replies
Relevance 73.39%

I found a post on this exact topic from back in 2010. I am trying to incorporate the code into my database and am not able to get the code to work if I make any changes. Here is the link to the previous thread: http://forums.techguy.org/business-...increment-field-including-year-restart-2.html

I have also uploaded the database that was provided in the last post. If I try to change the field and object names I appear to be unsuccessful in having the code still work even when I change the items in the code as well. I woud like some help. I would like for there to be a field called "RequestDate" that has the date stamp that is keyed in by the user. Then after that is keyed in on the form the "AssignmentID" field is updated to the new assignment number. The "RequestDate"="Admit_Date" and "AssignmentID"="ActualFWCNumber". I am trying to do this in Access 2010. If I make changes either the number field doesn't autopopulate or the same number keeps repeating. Any and all assistance on this would be great.
 

Answer:Autoincrement field including year - restart each year

tamanthalou, welcome to the forum.
As you have posted the original database a copy of your database with no data in it would be better to understand your problem.
 

1 more replies
Relevance 73.39%

Hi,
I've read every post I could find on this so I'm sorry to ask another dumb question but here goes.

I created an access database (volunteer work) which has an autoincrement field to issue numbers to animals taken in at our shelter. My 'boss' (also a volunteer) wants this simple autoincrement changed to a value which begins with the two digit year and then has 4 digits, starting with 0001 which will increment sequentially and restart at 0001 with the new calendar year. Therefore, records will start with 10-0001, 10-0002, etc for this year and 11-0001, 11-0002 for next year.

Any help would be greatly appreciated.
 

Answer:Autoincrement field including year - restart each year

16 more replies
Relevance 70.52%

I use due dates on my Outlook tasks. When I customize my Tasks list (in the Calendar view) to group by due date, I just get too many groupings (one for each due date!). I would like to know if I can create a custom field called 'Due Month' and/or 'Due Week', extracted from the 'Due Date', so I can view my tasks by what is due during a given week or month. If the answer is yes, any suggestions on the technique I would use would be greatly appreciated.
Thanks in advance,
Mac
 

More replies
Relevance 69.7%

I need a date field changed into a text field of YYYYMMDD so for example the date of birth field is 3/17/1953 and I need that converted to 19530317 in the Excel spreadsheet. Thanks.

Answer:I need a date field changed into a text field of YYYYMMDD

under the format options.

5 more replies
Relevance 67.24%

First the background: We are gradually deploying Office 2007, but not everyone in the agency has it. I have both 2003 and 2007 installed on my system, but I do my work in 2003, and none of our databases have actually been converted to 2007 format (at least, none that I work with). There are occasionally people who use 2007 when viewing databases, but I don't know if any of the people who are working in this particular database are using 2007. The problem is reproducible in 2003 and so I've been trying to fix it here. The query behind the problem report used to work. It has been a problem for several months (it is run monthly, and every month for the past five they've had problems with it) and I've finally gotten to the root of the actual issue.

The purpose of the report is to generate invoice for outstanding loans. The DateNextPayment is a calculated field based on the payment plan for the loan. It is calculated using a function in the query named qryGetSitesDDInvoices1. This is the function that is called (I did not write this function, I'm supporting this db long after the original writer has left):
Code:
Function DateNextPayment(PaymentSchedule As String, DateFirstPayment As Date, Balance As Currency)

On Error GoTo Handle_err

Dim Date1 As Date
Dim Date2 As Date
Dim Date3 As Date
Dim NextQtrDate As Date

'The code adds one month to datenextpayment at start of each month. Or yearly or weekly

... Read more

Answer:Solved: Date Parameter Failing in Query from calculated date field using DateValue Ac

16 more replies
Relevance 66.42%

Hello,

I have a large report of application forms which have been submitted including the date when they were submitted however the dates are formatted incorrectly.

1. Although the cell formatting is dd/mm/yyyy the data is being shown in mm/dd/yyyy which means the dates are incorrect (e.g. 2nd January would read as 1st February.)
2. As a result of this dates which are passed the 12th of a month are not accepted as dates (it reads the day figure as months and there is no 13th month etc)

I have tried to use the text to columns function but that makes no difference and I have tried to extract just the dates but I've had no luck.

Can anyone help, I've attached a small sample of the data.

Thanks

Daniel
 

Answer:Exported date field not recognized as date in Excel

Where does the data come from?
What do you get if you have no cell format?
 

3 more replies
Relevance 66.42%

I accidentally formatted the date cell & it only accept numbers

Answer:how to correct a date field when you enter a date a number a

I don't know what you mean by "it only accepts numbers".Why can't you just format it as a date again?Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

2 more replies
Relevance 65.19%

Help! This should be easy but I can't get it to work.

I have a report that must group by Trip# and sort by ascending activity date all of the various activities that took place on multiple days of the trip.
Further, the trip with the earliest date must come first regardless of the Trip#.
I've accomplished getting the earliest starting date trip first and grouping its detail with a unique string made up of the earliest date of each trip formatted to YYYYMMDD+Trip#. This prints a trip total and works fine.

But the daily activity for the trip is out of date sequence.
Adding a Date field to the 'Sorting and Grouping' insists on breaking on and printing a sub-total for each of the trips activity dates.
Without the sorting & grouping by date the trip records are out of sequence even though the data source query is sorted ascending by activity date.

(see attachments that show the above)

The only solution I can think of is to create a sub-report sorted by activity date.

Does anyone have any better ideas?

Jim Shannon
JES Computer Systems
Access Developer.
 

Answer:How sort by 2nd field (date) without grouping when date changes?

7 more replies
Relevance 59.04%

Is it possible with Access 2010 to have a date field that would change to current date whenever another particular field is modified. For example, we have comment field and we would like to have another date field that would change to the current date when the comment field has a change.
 

Answer:field modified date

Yes you can do it with simple VBA code, you could also add it to the comment itself, so it appears at the beginning of the comment.
 

1 more replies
Relevance 59.04%

Not sure how to go about this. I am not a programmer by any means but need to make a program.

I have a text file that is in what is called BAI format (bank standard format to send info). Basically this is a CSV file with a header. Right now I use a mail merge file to update the date field. I am looking to automate this so I would only need one "dummy" file and have a program that will update the date field automatically. The file is opened with notepad. I have done some VB but not a lot. I am looking for the best way to go about doing this. I tried to get some of the programmers to do it but no one wants to worry about supporting it, so I am taking a crack at it.

All help is very much appreciated. One idea I had is maybe a macro in excel but not sure if it would mess up the formating. I will try to get a copy of the file I use and post it.
 

Answer:Updating date field

6 more replies
Relevance 59.04%
Question: Update date field

Thanks in advance for your help!

I used to know this and I did a search and couldn't find the answer.

How do you update a field to a date either 6 months away or 12 months away for the current date in that field?

Thanks again!
 

Answer:Update date field

6 more replies
Relevance 59.04%

Hi,I'm trying to create an if formula and I'm a bit stuck.Column L contains dates separated by commas. I'm trying to create a formula to say:if L2 contains (fixed date from a single cell) then "Exclude" else "No"There are two issues. How do I make the if statement contains not just equals? How do I copy the cells down and keep the field with date in fixed?For example I added the date I needed to 'Delivery sheets d1':=IF(Data!L2='Delivery sheets'!D1,"exclude","No") but when I try and fill down the D1 continues in a series e.g. d1, d2, d3 etcI hope this makes sense. Thanks in advance!

More replies
Relevance 58.22%

hi, i searched in vain for an answer to this question:
when i edit an image file and resave, the date modified date does not change. since i started using computers 100s of years ago, this was automatic. how can i enable this (obvious) field? what point is there in even having a date modified field if it stays the same as the date created field? thanks!

Answer:date modification field does not change

Are you sure you have the Date Modified selected as a column to display?

Right click on the header column (has Name, Date, Type, etc.) and select the Date Modified tag.

9 more replies
Relevance 58.22%

Can someone help please?

I'm setting up a query in Excel from an SQL database. How do I (or what do I) do to ensure only todays data is shown - I suppose I'm looking for an"=TODAY" type thing but don't know enough to be able to do it.

Thanks in anticipation.

Moll )
 

Answer:Excel query on Date field

it can depend on how the date system is set up but the following page has pretty much every SQL date function going

http://www.connx.com/products/connx/Connx%208.5%20UserGuide/sql_date.htm
 

1 more replies
Relevance 58.22%

Hi guys,

Something weird is happening. Some of my movie files (file type doesn't matter) became corrupted; when I play them in VLC they cause errors, they were just fine before and nothing has changed. I noticed in Explorer that these files have no Date Modified field, it's simply blank; I've never seen anything like that.

I did a chkdsk on the drive and see no errors. What could it be ?

Thanks.

Answer:Blank Date Modified Field ?

VLC should rebuild the Index, but that is a temporary fix. Depending on what format they are, there is "DIVFIX" and "Meteor MKV repair" you can try to run the faulty content through which of those is appropriate, you'll have to google it, cant remember the links.

3 more replies
Relevance 58.22%

Hello everyone,

I'm working on an order management database and I'm stuck on one item.

I have a form that users can fill in with purchase order data. One section of the form relates to contract review completion.

I would like to have a checkbox that the user can check when contract review is complete, but I'd also like for a completion date field to be auto-filled when the checkbox is checked.

I've tried a couple of things, both unsuccessful.

Any ideas?

Thanks.
 

Answer:MS Access - autofill date field

6 more replies
Relevance 58.22%

Is there a way to insert a date merge field where the date is spelled out (June 10, 2008) and will not change if the document is reopened, resaved, modified, etc?   Thanks for any help!

Answer:MS Word merge field for date

I'm not quite sure I understand the question, but depending on the Word document...you can use the "Insert" link from Word's toolbar to insert the date into a document...formatted to your liking.Once the document is saved...the date will always appear as you have set it.

2 more replies
Relevance 58.22%

Hello, I need help with the following:
I have a field (called Date_Time) which displays for example 1/31/2005 12:00:00 AM. I would like to run a query that converts that value to '200501' in a created field.
I tried the following below but I keep having problems.

select Account_Number, Date_Time,
concat(year(Date_Time), month(Date_Time)) as Date_Time_Modified
from table
where Account_Number = xxxx

Any insight into this would be greatly appreciated. Thank you.


 

Answer:Concatenating Date and Time Field in SQL

Just wanted to add some more examples:

Account_Number: Integer Type
Date_Time: Date Type
Date_Time: Modified: Character Type

Account_Number Date_Time Date_Time_Modified
3246 1/31/2005 12:00:00 AM 200501
4920 11/30/2008 12:00:00 AM 200811
5932 6/30/2011 12:00:00 AM 201106
... ... ....
 

1 more replies
Relevance 57.81%

I need a macro to keep track of Year to Date to use in a very simple payroll worksheet, or maybe an Excel formula that will do this.All I will be using this for is to add additional information to weekly paystubs.I don't have a regular payroll program,just a worksheet that figures paycheck earning and deductions.
Thank-you, Bud
 

Answer:Solved: Year To Date

10 more replies
Relevance 57.81%

Is it possible to convert the day of year to a date.(Assuming all number are for 2004)Example 001 to 01/01/2004or 366 to 31/12/2004

Answer:Excel - Day of year to date

click here and download the zip version it may be of some help?That is until say the likes of VoG sees this posting.

10 more replies
Relevance 57.81%

Windows Vista ...

http://blogs.msdn.com/conblog/archive/2006/03/14/550826.aspx
 

Answer:This is the year ... and November is the date

Damn - so just after i would have bought a laptop.

Do you reckon it would be worth waiting? When do you think it will be coming as standard with OTS systems?
 

13 more replies
Relevance 57.81%

Hi all, I am a newbie, but am hoping someone can help me shed some light. Night before last I shut my computer down as I try to do once a week. Before leaving for work I started it back up and left~ When I got home the computer was on but all of the folders, programs and icons are from a year ago. We tried restarting and went through a few different steps to try to figure out if something was different but couldn't see any changes. Ran a tsskiller~ and no threats were found on the computer. And none of my external hard drives are recognized~ as a pro photog I am a little concerned. Has anyone heard of something like this happening as I have not. thanks so much! ~S.
 

Answer:Starting from a Date over a Year Ago

Iv'e seen something like that , if/when a hard drive is starting to fail, it can lose data.... see if chkdsk reveals anything http://www.vistax64.com/tutorials/67612-check-disk-chkdsk.html
then I would run a test on the hard drive from the maker of the drive itself... if you can't find yours, heres one iv'e seen recommended before... http://pcsupport.about.com/od/toolsofthetrade/gr/seagateseatools.htm

good luck
 

1 more replies
Relevance 57.81%
Question: year 2000 Date

I've just upgraded my computer with a new mobo, cpu and HD so i'm not sure if this is a hardware or software question, if this is in the wrong forum please forgive me.
When i first loaded windows i didn't put the right date in somehow i put 2000 in the date. I changed the date when the OS was fullly loaded
But now when i try to load Norton it says my subscription is out of date, it says installed 2000 and and subscription ended 2001
I've done everything i can think of to fully uninstall Norton, uninstalled the program, used their removal tool, removed everything from Registry with Registry Mechanic, done everything i can think of but it still keeps happening.
So i wondered if there is a date somewhere related to the computer as opposed to the software that keeps telling Norton its the year 2000.
I've checked the date in the Bios and it is the right date.
Thank you for your help
 

Answer:year 2000 Date

Doesn't sound like your computer is reporting the wrong date. As long as it shows the right date in both BIOS and windows, it should be right. Norton Live Update is a paid service, meaning you actually have to pay them (annually i think) to get the updates. If you have legitimately subscribed to their service then i suggest you contact their customer support. If you have not subscribed and do no wish to pay to get virus protection (assuming you're talking about Norton AV), then I suggest you get this very good free antivirus program (better than Norton imo): AVG Anti Virus

here's their site: http://www.grisoft.com/doc/1
 

1 more replies
Relevance 57.81%

every time i turn on my comp.it has 2007 and 12:02am.i have to set the correct date and time every time i turn on the comp

Answer:wrong date and year

Sounds like your CMOS battery died. The replacement battery and the method used is dependent on your particular make/model. How To Ask Questions The Smart Way

11 more replies
Relevance 57.81%

I have in column A dates from 1980 through 2010. I want to work with only the day date and monthly date. mm/dd. Howevery Excel will not drop the year date. Date is formatted as, "mm/dd/yyyy". Is there a "wild card" or something that I can use, like mm/dd/#### ? Or is there a way I can tell Excel to use only dd/mm ?I'm working In Excel 2007Thank you for any input

Answer:Date but drop the year?

When you say "I want to work with only the day date and monthly date. mm/dd" do you mean that you want Excel ignore the year (e.g. 11/25/2008 is equivalent to 11/25/2010) or do you mean that you just don't want Excel to display the year, but still retain it for date related calculations, etc.?I guess is all depends on what you plan to do with the result.With 11/25/2008 in A1 this will display 11/25, but it won't be a date anymore, it will be text:=MONTH(A1) & "/"&DAY(A1)With 11/25/2008 in A1, this format will display 11/25 and the date will still be a date, it just won't display the year.Format...Custom mm/ddFinally, if you need it to be a date, but don't care if every Month/Day has a year of 2010, try this:With 11/25/2008 in A1, use:=DATEVALUE(MONTH(A1) & "/"&DAY(A1))Format...Custom mm/ddEvery "date" set up like that will have the current year associated with it, e.g. 2010

4 more replies
Relevance 57.81%
Question: year to date chart

im making a chart that shows running totals for the week the month year etc. every week i reset the stats for the week and when i do it subtracts whatever the weekly number was from the month year etc what is the formula to tell it not to subtract but to stay at highest number when i reset the week stats and continue counting

Answer:year to date chart

Hi,I suggest you read your own post from the point of view of someone who has never seen your worksheets, or your charts and has no idea what formulas have been used, and has no idea about what data is being used, or where it is stored.From that point of view it should be clear that your question is pretty much unanswerable!I suggest that you identify where your problem is and provide clear information on what is not working, including the relevant formula(s), the nature and location of data etc. etc.Then read your question and consider if there is enough information in the question for someone not sitting in front of your PC to potentially come up with a solution. Regards

4 more replies
Relevance 57.4%

Hello,Have a Excel file with multiple sheets , each sheet is identified by the persons ID numberSee attached file.Here i need to copy data from FILE1 in each sheet to FILE2As you see in file1 that data for each person is scar tared , that is date are up and down ...that data need to be moved to file2 where already date from 21 oct to 20 nov is marked.THANKS

More replies
Relevance 57.4%

I have tried sending a message to a friend who, up until now has had no problem receiving. The message I am sending has no attachments. But this message has come back several times with the message:

This message has been rejected because it has
an overlength date field which can be used
to subvert Microsoft mail programs
The following URL has further information
http://www.securityfocus.com/frames/?content=/templates/article.html?id=61

but when I go to that hyperlink it is a page saying that the item 'might' have been removed.

Incidentally I have an uo to date virus checker running and have been able to send and receive emails to others since the first bounce of this email

Questions:
1. Is this a genuine response or some sort of problem at receivers end?
2. If genuine can someone explain what I might need to do, if anything can be done, at my end to get the message through. I have already tried maing the subject line smaller but that made no difference.
 

More replies
Relevance 57.4%

I receive periodic Word (.rtf) documents from a property rental agency whenever my property is rented. The document contains the dates rented, the renter's name, etc. There is a "date field" in each document which automatically shows today's date, rather than the date the doc was created and sent to me. If I want to forward the doc to the renter a week later how do I stop the date from updating when I send it and stop it from updating when the renter opens the file?
 

Answer:Solved: Stop Updating the Date Field

6 more replies
Relevance 57.4%

the answer to this might of been found with a search but hey i'm lazy today and wanted to see who the excel masters are

using excel 2007, cell a1 contains an array formula (CSE) like so - {=MAX(LEN(A2:A470000))}
cells a2 through a470000 contain dates such as
12/12/2011
etc, you get the idea, i need the formula or something else entirely to return 10 not 5

thanks in advance
 

Answer:Solved: excel length of date field

i'll answer if myself thanks to another web site, Mike these guys are slackin' 'round here it looks like

=MAX(LEN(TEXT(A2:A470000,"m/d/yyyy")))

exit celll with ctrl, shift, enter
 

1 more replies
Relevance 57.4%

I am trying to add a sequential number to a date field in an Access form.
The format of the field is PS 18 Jan 11 xx, the PS is fixed, the current date and the xx is my sequential number I want to add.

Is there a way, to do this when the date is entered? And I would need the sequential number to reset to 01 with a new day.

I'm new to this, any help would be great!

Thanks!
 

Answer:Help in appending a sequential number to a date field

16 more replies
Relevance 57.4%

How do you insert a date field in Word 2007?

Answer:How do you insert a date field in Word 2007?

In Office 2010 at least, it should be under the "Home" or "Insert " tab. Then there should be a sub-category like "Date" or "Time".By the way. In the future, you'll get better office results here:http://www.computing.net/forum/offi...Ask and Answer. The way of learning.Dell Dimension 8300Intel Pentium 4 HT @ 3.20 GHz4 GB RAMNvidia Geforce FX5200

2 more replies
Relevance 57.4%

Have sent email to several friends, there is no attachment, just relatively straight forward item with some borders and a table in the email body copy. In one case the email was bounced back as 'delivery failed' with the message:This message has been rejected because it has an overlength date field which can be used to subvert Microsoft mail programs The following URL has further information click hereHave gone to hyperlink which says 'page removed'. Other emails I sent to this friend get through. My questions are:1. I assume this is a genuine block?2. Has anyone come across this and do you know what it means?3. Is there something I can do to get my message through? [I had put a lot of work into it]Many thanks Tiggertwo using Outlook Express and windows95

Answer:Email bounced 'overlength date field'

Sounds like some sort of anti spam program which is a little too zealous. Have you tried it again to the same user?

1 more replies
Relevance 57.4%

Greetings

It's been a long time since I last posted here, but hopefully all you wonderful people will be able to help...

Here is my problem:

A customer of mine has a SQL database where one of the fields is a date/time field that looks like this:

13/02/2003 14:32:58
14/02/2003 08:59:10
15/02/2003 17:09:37

Now, I need to delete all the records for a particular day (One of their HD's failed, and they had to restore the data and lost a day, but the entries are still in the database, and can not be re-entered until the old entries are deleted).

How do I structure a query to delete all the records for a particular day? Preferably, I would like a SELECT statement first, just to check that the records found correspond to the delete criteria, and then the DELETE statement.

Thanks

Reuel Miller

The Ex-NT moderator on this board

Every morning is the dawn of a new error
 

Answer:SQL Query help required with date/time field

Greetings

Not to worry chaps, I figured out the answer all by my lonesome

the statements I used were:

select * from {database name} where {date field} > '14 February 2003' and {date field} < '15 February 2003'

delete from {database name} where {date field} > '14 February 2003' and {date field} < '15 February 2003'
cheers

Reuel Miller
 

1 more replies
Relevance 57.4%

Hello,Have a Excel file with multiple sheets , each sheet is identified by the persons ID numberSee attached file.Here i need to copy data from FILE1 in each sheet to FILE2As you see in file1 that data for each person is scar tared , that is date are up and down ...that data need to be moved to file2 where already date from 21 oct to 20 nov is marked.THANKS

Answer:Moving rows with Date field from one worksheet to another

Quotei need to copy data from FILE1 in each sheet to FILE2I'm wondering about the wording of the quoted part of your post.  I suspect it would be better worded like this: i need to copy data from each sheet in FILE1 in to corresponding sheets in FILE2.   Is that correct?  Are FILE1 and FILE2 names of separate Excel files?

14 more replies
Relevance 57.4%

I want to combine a text field and a date field into one field to use as a reference number. IE 'Mil - 05/11'.

I have got a field with the standard short date format 29/05/2011 (that I have to keep) and I have created a second field with the same date but formatted to a "mm/yy". When I concatenate the Operater Ref field "Mil" to the Date Ref field "05/11" I still get the full date format IE Mil - 29/05/2011.
 

Answer:MS Access Concatenate a date and text field

Jerry-

If you are creating the second field in your table, go to design view and change the Data Type to Text then try your concatenation. I built a mini-table and queried it and this worked for me... hope this works for you!
 

19 more replies
Relevance 56.99%

Hi, i am trying to figure out a starting date based on a 360 day year, or 30 day months. I have the following information: End date, and the number of days that I need to go back to calculate the start date. For example: End Date = 9/14/08; Number of days to go back = 180. So the start date that i am looking to return is 3/14/08 (not 3/18/08), which can be verified using the =Days360() function. thank you in advance!
 

Answer:Need help in Excel with date function on a 360 day year

Code:
a1=14.05.2008
a2=181
a3=date(year(a2);month(a2)-rounddown(a3/30;0);day(a2)-(a3-rounddown(a3/30;0)*30))
 

1 more replies
Relevance 56.99%

Whenever I boot my PC, the date is always a year from the current date. I go into the date and time settings and reset it, but the next time I start the machine a year has been added. The same thing occurs if the PC is on past midnight. At 11:59:59 the date will be 1-29-2001, but then it becomes 1-30-2002.

This is a 3-month old Gateway P933. Gateway says this is 'impossible' and that some software must be setting the date incorrectly. I've run 2 virus checkers (nothing found) and don't have any unusual programs running automatically. I KNOW that this IS possible because it's happening. What are some possible causes.

Thanks
 

Answer:Date always resets to a year from today

7 more replies
Relevance 56.99%

Anyone got an alternative list up their sleeve?

Answer:Spyware Warrior is a year out of date

click herethis may help...

1 more replies
Relevance 56.99%

Hi to all,

In my form, I've a text box that has a input mask: 99/99/0000;0;_ and the Format: Short Date.

How can I ensure that the user enter day (1-31 and 28/29 depending on leap year), month (1-12) and year (starting from 2000).

Thanks!
 

Answer:Validate date (Day 1-31/ Month 1-12/ Year)

8 more replies
Relevance 56.99%

Hi!
Maybe it's just my imagination, I think I heard or saw somewhere that it's possible to change the date format in the computer and e-mail program. I prefer to have everything in the computer appear as;
Month/Day/Year
Is there a very easy way to this? Would it cause conflicts with anything?

Thanks!


Windows XP Home
Outlook Express 6
 

Answer:Date Format (Month/Day/Year)

It should already be like that if you chose Canada as your location.

Anyway, in Control Panel click Regional Settings, then in the drop-down box select your country, then click Customize and select the format you want.
 

3 more replies
Relevance 56.99%

The free SiteAdvisor browser add-in claims to protect you by labeling Web sites green, yellow, or red to indicate that they are safe, questionable, or dangerous.But a good or bad SiteAdvisor rating can persist for as long as a year after the site's content has changed, raising serious questions about the service's usefulness...http://windowssecrets.com/2009/02/12/01-Si...ear-out-of-date

Answer:SiteAdvisor ratings may be 1 year out-of-date

i knew i should have just stayed with WOT...

7 more replies
Relevance 56.99%

"The free SiteAdvisor browser add-in claims to protect you by labeling Web sites green, yellow, or red to indicate that they are safe, questionable, or dangerous.

But a good or bad SiteAdvisor rating can persist for as long as a year after the site's content has changed, raising serious questions about the service's usefulness.

McAfee certifies for a fee, but it's no guarantee.

For the smallest sites, SECURE certification costs $859 annually plus a $100 setup fee. If a site gets more than 2,000 page views per day &#8212; a tiny number for any serious e-commerce destination &#8212; the price rises. McAfee measures traffic by inserting a bit of HTML into the site's pages.

After a site ponies up the cash, a security audit is performed, according to a description by McAfee. This audit (formerly known as McAfee HackerSafe certification) has long been criticized as permitting critical Web vulnerabilities, as outlined in a recent analysis by security researcher Mike Bailey.

Even paying for and passing SECURE certification, however, doesn't guarantee that a site with a false rating in SiteAdvisor will get the red flag corrected immediately."
http://WindowsSecrets.com/comp/090212

McAfee sounds like a nice user friendly company
 

Answer:SiteAdvisor ratings may be 1 year out-of-date

7 more replies
Relevance 56.99%

The system date in my PC couldn't be changed via Control Panel. The 'Year' is always jumping from '1990' & '1994' when I opened the 'Date & Time" in Control Panel. When I tried to change it to '2007' and click 'Apply', the 'Year' is still showing '1990' or '1994'. I could change the 'Year' successfully when I boot up the Window in Safe mode.

I tried to scan the virus/spyware by Norton & AVG Anti-Spyware, but no virus/spyware is found. Any idea on the problem ? Please help.

Below is the Hijack logfile for reference, the date is showing year of '1990' as well :

Logfile of HijackThis v1.99.1
Scan saved at 5:49:47 AM, on 4/13/1990
Platform: Windows XP SP2 (WinNT 5.01.2600)
MSIE: Internet Explorer v7.00 (7.00.6000.16414)

Running processes:
C:\WINDOWS\System32\smss.exe
C:\WINDOWS\system32\winlogon.exe
C:\WINDOWS\system32\services.exe
C:\WINDOWS\system32\lsass.exe
C:\WINDOWS\system32\svchost.exe
C:\Program Files\Windows Defender\MsMpEng.exe
C:\WINDOWS\System32\svchost.exe
C:\Program Files\Intel\Wireless\Bin\EvtEng.exe
C:\Program Files\Intel\Wireless\Bin\S24EvMon.exe
C:\Program Files\Common Files\Symantec Shared\ccSetMgr.exe
C:\WINDOWS\Explorer.EXE
C:\Program Files\Common Files\Symantec Shared\ccEvtMgr.exe
C:\Program Files\Common Files\Symantec Shared\SNDSrvc.exe
C:\Program Files\Common Files\Symantec Shared\SPBBC\SPBBCSvc.exe
C:\Program Files\Common File... Read more

More replies
Relevance 56.99%

I had been using it with firefox and after upgrading it left a toolbar in IE which I disabled, but leaving it active in FF w/noscript. After getting too many false positives and missed advisories I will probably uninstall it.http://windowssecrets.com/2009/02/12/01-Si...-date/?n=story1

More replies
Relevance 56.99%

from email address removed by Dreamboat

I have a database with a date field; 'Birthday'.

I want to take the month info from the date field and have access put it into another (adjacent) field. Ie;

Name:
Addr:
Birthday:
Month of B'day (New Field)

Also I want to be able to query the birthday field from previous data base tables which do not have the month field and make a table with the month information extrapolated to a new 'Month of B'day' field.

(Month([Birthday])) does not work.

I have printed a report with the 'Month of B'day" info extrapolated to the report but it is not useful because the report does not sort by the new information.

I know these must be possible but . . . . . AAAaaagh I'm going nuts.
 

Answer:Solved: Extrapolate Month from an Access date field

16 more replies
Relevance 56.99%

I want to be able to place the date in reverse order in the subject line of new emails when I press a button on the toolbar. The format of the date should read '20061003' for the 3rd Oct 2006 - I know i should be able to use a macro or write VB scipt, bit i am not that clever - please help - many thanks

Answer:MS Outlook 2003 - Reverse Date in Subject Field

06.10.03 - subject.It's easier to read and there will not be a filing problem for the next 94 years or so.I'll leave the technical stuff to others

8 more replies
Relevance 56.99%

I have a linked Excel spreadsheet to show invoices received and I insert a date when they are paid. I cannot figure out the expression to use to show all records where no date has been inserted. Can anyone help please.Thankyou

More replies
Relevance 56.99%

I have an excel sheet with dates displayed in European format dd/mm/yyyy :-)I import it into a letter ("you have been a member since") and it imports in American mm/dd/yyyy.I can't see how to properly format the merge field

Answer:Mail merge a date field screws the formatting!

It all has to do with how your Operating System Date is set up.If your in the US then the default is mm/dd/yyyyYou can change how Excel Displays the date to dd/mm/yyyy, but it Stores the date in the System Date format of mm/dd/yyyy.When you import the date to Word, the System Date format is used.See here for how to change the format:http://cybertext.wordpress.com/2009...alsohttp://www.ashbee.co.uk/index.php/f...MIKEhttp://www.skeptic.com/

4 more replies
Relevance 56.99%

This one has got me. Has anyone figured out a way to do this easily? I can create a new column and extract the right characters and make it work ... but just wondering if there is a quicker way out there!

Thanks in advance for your time/help ...
 

Answer:Excel: Extract hour ONLY from a date/time field

Ok, got it to work ... but not sure if there is a better way.

I created a 2nd colummn and used the =RIGHT(D107,5) to isolate the time (10:32) from the date/time field (JAN 12,2014 10:32)

I then created another column and used =TIME(HOUR(C107),0,0) to pull out the hour ONLY in 10:00 AM format.

Is there a quicker way out there?
 

2 more replies
Relevance 56.99%

Hello

Access 2003
Windows XP

I am creating a new table and would like to format a field to short date. Here is my code. Is there a way to format to short date from here?

Thanks

Set fld = tbl.CreateField("Date", dbDate)
fld.Required = True
tbl.Fields.Append fld
 

Answer:Access 2003 - Format field to Short Date

try this:
fld.NumberFormat = "m/d/yyyy"
 

3 more replies
Relevance 56.99%

I have a field that is date/time, formatted to display the long date (which starts with the day of the week). This has been extremely useful for some append, update and delete queries.

However, I would like to be able to do an update query based on the day of the week for each record. I know that the date/time field is stored as a number so I can't search for any string of letters. But, is there a way to take the long date format and copy what's there as a string so I can then extract the day of the week out of it? Otherwise, I guess I'm stuck with adding a separate field for day of the week, and manually inputting it. Seems like such a waste.
 

Answer:Solved: Access, Date/Time Field to String -- is it possible

7 more replies
Relevance 56.99%

I have a Date field in a Form. I want the Date to be appear in red when it is more than 6 months older than today's date. Where and how do I make that happen?
Thanks
 

Answer:Access 2010 Date Field in Form Macro or ()Iff ??

10 more replies
Relevance 56.99%

Hi guys, I'm very new to access and I'm having some issues. I have made a field for an expiry date, and I have attempted to create a calculated yes/no field that gets ticked when the expiry date is up, so basically I have a box that I want ticked for when the expiry date is before the current date (I hope that makes sense). Thanks guys,

George
 

More replies
Relevance 56.99%

Hey everyone,

I'm having problems with Access, where I have a date/time field, which stores a month and a year (successfully), but still automatically assigns the first date of the month in question.

I used the following input mask (00/0000;;_) for the date field, and so far I haven't had any troubles with putting in a month and year. So far so good. But when I complete the date and move on, Access changes it to a full date. e.g. 06/2010 --> 01/06/2010.

Now, I'm actually fine with this part, my only problem is that I don't want it to do this in forms (both datasheet and normal view) or reports.

I heard something about using a Format (http://office.microsoft.com/en-us/access/HP010990151033.aspx) to adjust the display, but I can't seem to get that to work. Is there any other way to tell Access how to display the date field, like what can be done in Excel?

This is rather urgent as I have a project due tomorrow and this problem (as well as others) have now been reached and I'd like to solve them as soon as possible.

Any help is appreciated, and I look forward to your responses.
 

Answer:Solved: Urgent: How do you format the DISPLAY of a date field?

8 more replies
Relevance 56.99%

Hello,

In Access, I am trying to develop a process for generating a unique client number that follows a very specific formula: XXX - XXXX - X - XXXX. The first group should represent the quarter and year when the client is first introduced (non-standard year: Feb-Jan). The second group should be a unique, sequential ID number with leading zeros (missing numbers won't matter and leading zeros seems impossible, so I'm planning to use a DMax calculation on the form that generates a sequential number). The third number represents the client's initial program phase ID. The final number relates to the grant contract ID.

I have generated the number with the following in a Select query:

UniqueNumber: DatePart("q",DateAdd("m",-1,[MonthStart])) & Format([MonthStart],"yy") & "-" & [SeqNum] & "-" & [InitialPhaseID] & "-" & [ContractID]

The table already has a primary key, but since I am required to generate client numbers in this format, I want the UniqueNumber to be saved and searchable. This field never needs to change once the original record is saved. I've tried an Append query, but can't make it work. I assume it's related to the fact that I'm combining Date and Number fields, not to mention the DatePart function. I consistently get a key violation error. Any thoughts on how I can proceed?
 

More replies
Relevance 56.99%

The company I work for has asked me to work with the DB (as you may well guess in this economy I now have to learn how to work with Access DB. This DB was created by someone who had a book “Access 2000 for dummies” in 2002, I have since then converted the 2000 DB to 2007 accdb format. That being said, in a form that is used to track records-TS# is the primary key, they want a YES/NO or actual name- Completed *check box for yes and blank for no*. I created the check box as you may know that was easy enough. The problem comes in when I go to the next record the box remains in whatever state it was on the previous record and does not show up anywhere else. I am sure this is likely because there are steps that I am omitting or not aware of. Any help offered would be amazing as I continue to work on this train wreck.

-Mike
 

Answer:Solved: Access 2007 YES/NO field with time/date

Mike, the Check Box field has to be in the Table that the Form uses as it's Record Source. The Check box has to be "Bound" to that table's field, i.e. it's "Contorl Source" of the check box in design view must be the table field.
 

2 more replies
Relevance 56.99%

Hi all,

I am looking for help on VB script to send automated emails based on the date column in excel sheet..

Uploading the excel sheet as well. The email should trigger on dates in column F to corresponding email addressed in column E ..

The email body should say :
Hi,

Your employee "Column C" is approaching his probation period on "Col D". Kindly confirm if you want to confirm on the date of "Column D" or modify it.
 

Answer:Need help to send automated email based on the date field

Have a look at the attached I have written the code necessary however if you have any changes you would like made let me know.
 

1 more replies
Relevance 56.58%

I have a column of years in excel that I am trying to plot with another column of numbers in a bar graph. However, because the cells the years are in are not formatted as dates, excel is reading them as numbers, plotting them on the wrong axis, and not using the exact number. When I try to format the years cells to dates, there is no option to just list the year, and if I choose one that has a day, month, and year (mm/dd/yyyy for ex), it totally changes my original data (ie I have the year 1983 as one of my years and if I click on the mm/dd/yyyy option, it changes it to 6/5/05, etc). How do I format these cells without it changing the data I already have in it? Or, how do I plot this data as is?

Answer:Changing a year (yyyy) to date format

You need to understand how Excel stores dates, here is a quote from MS:"Excel stores all dates as integers and all times as decimal fractions. With this system, Excel can add, subtract, or compare dates and times just like any other numbers, and all dates are manipulated by using this system.In this system, the serial number 1 represents 1/1/1900 12:00:00 a.m. Times are stored as decimal numbers between .0 and .99999, where .0 is 00:00:00 and .99999 is 23:59:59. The date integers and time decimal fractions can be combined to create numbers that have a decimal and an integer portion. For example, the number 32331.06 represents the date and time 7/7/1988 1:26:24 a.m."So, with that being said, just entering the year 1983, as you know, gives you a Date of 6/5/1905 or 1983 days since 1/1/1900.You cannot get just the Year alone, as Excel does not understand it as a Date.You could try using 01/01/1983 and then using a Custom Format to display it as just the year by using YYYY.MIKEhttp://www.skeptic.com/

4 more replies
Relevance 56.58%

Recently I noticed that every time I switch on/off the computer, the year in the Date and Time becomes 2005, while the date and time remain unchanged.
When I try to synchronize with windows time server it says the year has to be correct for synchronizing the time. But in my case only Year is changint to 2005.
Please help...can it be a problem with the RTC (Real Time clock) battery of my system...it's 6 years old now.
Please advice,
thanks
 

Answer:Computer date- year goes back to 2005

7 more replies
Relevance 56.58%

I have been using Iomega Network Harddrive 250GB for years connected thru the router. When trying to change the date for this years daylight saving time, the year 2013 is NOT in the drop down list.

I have not updated the firmware in all these years and cannot find any for this drive. The serial number is KUBH43A426. Any thoughts?

Regards,

Zzyzx

Answer:How Can I Change Date - Year Not In Dropdown List

  
Quote: Originally Posted by zzyzx48


I have been using Iomega Network Harddrive 250GB for years connected thru the router. When trying to change the date for this years daylight saving time, the year 2013 is NOT in the drop down list.

I have not updated the firmware in all these years and cannot find any for this drive. The serial number is KUBH43A426. Any thoughts?

Regards,

Zzyzx


This is a "shot in the dark", but is the current year omitted by design? In other words, if you select 2014, for example, is it omitted from the list and does 2013 show as an entry?

8 more replies
Relevance 56.58%

Encountered a small but irritating problem between Access 2000 and Access 2003. Designed a table and input form in Access 2000 that contain a date field to capture credit card expiration dates, which are always only month and year. Made the format "m/yy" with an input mask of #0/00;0;_. Works perfectly in my Access 2000, but when I installed the application on a client's (non-profit org.) computers, which have Access 2003, every entry of a year other than this year (06) gets changed to 06. E.g., if the user enters 0508 and tabs to the next field, it displays "5/06". It behaves as though it thinks you entered only the month and DAY, but since the format has to be m/yy, it displays the 5 and tacks on the current year.

Access (at least Access 2000) does not offer a built-in month/year format. So how can I make the field understand that what goes in there is supposed to be only month and year? Is it possible to do with a Date/Time field type, or do I need to make it Text, or what?
 

Answer:Solved: Month/Year date format

i'm a surprised on the M/YY format - how doesOct Nov Dec work 10/11/12
should the format be MM/YY
 

3 more replies
Relevance 56.58%

I have a date column displaying all payment dates.

Is it possible for the user to query by year only, thus displaying payments only from the desired year? [DD/MM/####]

I know how to set up input queries, but am not sure how to prompt for only the year correctly. Thanks for any help!!
 

Answer:Date Column, Query Criteria only Year

6 more replies
Relevance 56.58%

please help,

virus changes the date back to year 2005. (Kaspersky starts defucntioning due to that)

plz help!!

thanks in advance

+++++++++++++++++++++++++++++++++++++++++++++++++++++++

Logfile of HijackThis v1.99.1
Scan saved at 10:05:44 PM, on 12/22/2007
Platform: Windows XP SP2 (WinNT 5.01.2600)
MSIE: Internet Explorer v6.00 SP2 (6.00.2900.2180)

Running processes:
C:\WINDOWS\System32\smss.exe
C:\WINDOWS\system32\winlogon.exe
C:\WINDOWS\system32\services.exe
C:\WINDOWS\system32\lsass.exe
C:\WINDOWS\system32\svchost.exe
C:\WINDOWS\System32\svchost.exe
C:\WINDOWS\system32\spoolsv.exe
C:\WINDOWS\explorer.exe
C:\WINDOWS\SOUNDMAN.EXE
C:\Program Files\Java\jre1.6.0_03\bin\jusched.exe
C:\WINDOWS\FixCamera.exe
C:\WINDOWS\tsnp325.exe
C:\WINDOWS\vsnp325.exe
C:\Program Files\Kaspersky Lab\Kaspersky Internet Security 7.0\avp.exe
C:\WINDOWS\system32\ctfmon.exe
C:\Program Files\Kaspersky Lab\Kaspersky Internet Security 7.0\avp.exe
C:\WINDOWS\System32\svchost.exe
C:\Program Files\Internet Explorer\iexplore.exe
C:\WINDOWS\system32\rundll32.exe
C:\Program Files\Kaspersky Lab\Kaspersky Internet Security 7.0\avp.exe
C:\WINDOWS\system32\NOTEPAD.EXE
K:\Important Softwares\hijackthis\HijackThis.exe

F2 - REG:system.ini: Shell=explorer.exe "svchost.exe"
O2 - BHO: (no name) - {02478D38-C3F9-4efb-9B51-7695ECA05670} - (no file)
... Read more

Answer:Virus Changes the Date back to year 2005 :( plz help!!

Do a HijackThis scan & place a check next to these items and select "Fix checked":

F2 - REG:system.ini: Shell=explorer.exe "svchost.exe"
O4 - HKLM\..\Run: [ASocksrv] SocksA.exe
O4 - HKLM\..\Run: [WinSysM] C:\WINDOWS\273100M.exe
O4 - HKLM\..\Run: [WinSysW] C:\WINDOWS\273100L.exe
O4 - HKLM\..\Run: [upxdnd] C:\WINDOWS\upxdnd.exe
O4 - HKLM\..\Run: [LotusHlp] C:\WINDOWS\LotusHlp.exe
O4 - HKLM\..\Run: [mppds] C:\WINDOWS\mppds.exe
O4 - HKLM\..\Run: [AVPSrv] C:\WINDOWS\AVPSrv.exE
O4 - HKLM\..\Run: [Kvsc3] C:\WINDOWS\Kvsc3.exE
O4 - HKLM\..\Run: [MsIMMs32] C:\WINDOWS\MsIMMs32.exE
O4 - HKLM\..\Run: [SSLDyn] C:\WINDOWS\SSLDyn.exe
O4 - HKLM\..\Run: [DbgHlp32] C:\WINDOWS\DbgHlp32.exe
O4 - HKLM\..\Run: [PTSShell] C:\WINDOWS\PTSShell.exe
O4 - HKLM\..\Run: [cmdbcs] C:\WINDOWS\cmdbcs.exe
O4 - HKLM\..\Run: [msccrt] C:\WINDOWS\msccrt.exe
O23 - Service: 40B9CB77 - Unknown owner - C:\WINDOWS\system32\280E6F14.EXE

Ignore any prompts for a reboot
---------------
www.bleepingcomputer.com
www.forospyware.com
www.geekstogo.com

1. Please choose from any of the above links. Download the file & Save it to Desktop.

2. Double click on ComboFix.exe & follow the prompts.

3. When finished, it shall produce a log for you. Post that & a fresh Hijackthis log in your next reply

Note:
Do not mouseclick combofix's window whilst it's running. That may cause it to stall

16 more replies
Relevance 56.58%

Hi to all ... Is windows xp really that use easier to use than mac? Can they be networked togeher?
 

Answer:Its leap year and the wrong date is on my computer!

11 more replies
Relevance 56.17%

How do I stop update of date field in Word? I set the date to original date and try to save as PDF but it updates on save.

Answer:can't stop date field in Word from auto update in old docs

What did you do to get the Date, Insert --> Date and Time?Or did you use a DATE FIELD:If you are using: { DATE } Then it will always display TODAY'S date.If you are using: { CREATEDATE } Then it will display the date the document was created or saved using Save As.MIKEhttp://www.skeptic.com/

2 more replies
Relevance 56.17%

I want to add a validation rule to a date/time field in Access 2010. This worked in 2003 and I'd like to know why it won't work now.

The rule is

Is Null Or <= Date()

I have entered this through the expression builder as well as typing it to avoid typos.

The error message is:

Unknown function 'Date' in validation expression or default value on 'Artists.Date edited'.

I am doing this at work: we are running Windows 8, Server 2012, Access 2010 via virtual desktop.

Any help would be gratefully received!

Thank you
Alison
 

Answer:Solved: Access 2010 date field validation problem

Alison, welcome to the Forum.
I think you will find that this is an Access problem of Access 2010.
You may be able to overcome it by using Now() instead of Date().
If not I can provide you with some simple VBA code that will do the same thing that may work.
I have also seen advice to open a new 2010 blank database and import everything in to it to solve this problem.
 

2 more replies
Relevance 56.17%

Good day guys

My puzzler today (and has been for ages) is this:

In my Access report, I pull in "StartDate" and "EndDate" fields from the calling form and wish to display them as part of a report subtitle.

I therefore have a field called "DateDetails" in my report header whose ControlSource is:
Code:
="Records Selected between " & Forms!Reports!StartDate & " and " & Forms!Reports!EndDate
The dates actually derive from a table and the date format for both fields in that table is "General Date".

The result is that the report shows the following as an example:
Records Selected between 17/05/07 12:00:07 and 10/08/07 12:00:07

BUT what I want is the following:

Records Selected between 17/05/07 and 10/08/07

or even nicer

Records Selected between 17-May-2007 and 10-August-2007

Can this be done in such a control?

Chris
 

Answer:Solved: Access 2003 - Date Format in a Calculated Field

7 more replies
Relevance 56.17%

I am furious at not knowing why my date/clock in Windows 7 keep changins its appearance. It is as if the files or settings for Windows change mysteriously back and forth and I don't like it one bit.

The issue pertains to this clock/date shown at the bottom right corner on the screen just beside the system tray.

Sometimes it tells me the clock and no date or anything else is shown.
Some hours later it changes mysteriously to show the clock and the date format I once set, so that I get to see the day of the week, the date in numeral and the month in letters, and finally showing the year.

Something appear to be horribly wrong in Windows and I have no hope fixing it.

Only hope here is if this issue is familiar to other people.

Answer:Weird behavior by Windows 7, clock/date field changing

Do these changes happen when you hover your curser over the date? A few screenshots would be helpful!

9 more replies
Relevance 56.17%

I've searched the forum and can't find the help I need...perhaps I'm not using the right keywords.

Anyway, I want to automatically have a time stamp entered in a field named "CancelDate" if a yes/no field named "Cancel?" is checked. On the form I use an action button for that field.

I'm new with VBA, but after some research I entered this code in the AfterUpdate line in Properties:

Private Sub CancelDate_AfterUpdate()
If Me.txtCancel?.value = 1 Then Me.txtCancelDate = Now()
End If
End Sub

...and it doesn't work. It seems to hang up because of the question mark. I get a Compile Error: Expected:Then or GoTo.

Can anyone help me?
 

Answer:Solved: Access 2007 Record Date When Field Updated

10 more replies
Relevance 56.17%

While searching for some information in some old files, I noticed that every time I open a Word document, using Word 2007, the "date modified" shown in Windows Explorer automatically updates and changes the file properties to reflect the current date and time. I make no changes to the file and at no time am I asked to “Save” the document, which would justify the update of the “Date Modified” field.

This happens in both Vista and XP.

Is there any way I can change this setting? I only want the date modified to change when I actually make a modification to the document.
 

Answer:How to stop updates to Date Modified field in Windows Explorer

7 more replies
Relevance 56.17%

Access 2007 Update Query For Updating A Date Field

Hi I have been asked to write a query for an Access 2007 db

I need to update a date field in a table based on another date field in the same table

1st date field is the person's start date (StartDate)
2nd date field is the person's project date (ProjectDate)
Without going into too much detail, the Project Start date always begins on the 1st of the month

If the person's StartDate is between the 1st - 14th the project start date is counted as on the first day of the StartDate month/year

If the person's StartDate is between the 15th - end of month the project start date is counted on the 1st day of the NEXT month

Example:
StartDate = 7/1/2011
ProjectDate = 7/1/2011

StartDate = 7/14/2011
ProjectDate = 7/1/2011

StartDate = 7/15/2011
ProjectDate = 8/1/2011

StartDate = 7/30/2011
ProjectDate = 8/1/2011

I would like to update the ProjectDate in an update query

Any suggestions? Thanks
 

Answer:Access 2007 Update Query For Updating A Date Field

Create a Column heading like this
numdays: format([StartDate], "dd")
or
numdays: datepart("dd", [StartDate])
this will give you the day of the month on it's own
add a second Column
NewProjdate: IIf([numdays]>14,Format([StartDate],"mm")+1 & "/01/" & Format([StartDate],"yyyy"),Format([StartDate],"mm") & "/01/" & Format([StartDate],"yyyy"))

This will give you the date to use in the update query.
 

3 more replies
Relevance 55.76%

Hello I'm new to the forum and I saw a post bck in aug of 2012 where you helped someone fix a paystub for employees to do year to date figures. I need the same thing on a different type paystub and the only problem is I'm using the EXCEL for Ipad or Iphone and apparently it does not recognize macros. I guess I will have to make the suggestion to microsoft about that. Like they will listen.

Just wondering if you can help. If so please lmk and I'll send you the file I use. Thank you.

Blessings,
Leslie Wilson
 

Answer:Excel paystub for employees to do year to date figures

I have edited you post tile - from
Etaf - Wayne please helpClick to expand...

Can you add a link to the post you are referring to
also
Please upload a sample of your workbook to the forum, Make sure you have removed any private information, remember this is a public forum and so available to anyone
Would like to see an example of your data and also a manual mock up of the expected results you want to achieve.
 

1 more replies
Relevance 55.76%

Hi All,

When browsing (using IE6) to a directory in a certain FTP site some - not all - of the files created today are displayed with a date of exactly one year ago (Aug. 9 2006). Dir from command line FTP shows the correct dates. Any ideas?

TIA

More replies
Relevance 55.76%

When items are loaned out we want them returned in 30 working days (approximately 6 weeks I'm not going to bother trying to calculate holidays) but to only come back on a week day Monday through Friday.

Field Name ReturnDate_Fld this needs to be calculated as 30 working days from the current date

or should I not worry about the extra effort and use the approximate by adding 42 to the BorrowDate_Fld (plus 42 days = 6 weeks)

Should I worry about this in a form or only set it as field in the report/query?
 

Answer:Solved: Access 2010 Set a date field to today plus 30 working days

16 more replies
Relevance 55.76%

I have a Word 2010 document and I want to have specific text appear if a date is more than 42 days away from today (whatever today happens to be). I've got a three-cell table that looks like:


________________________________________________________

| DATE: | 12/25/13 | { =IF(B1-TODAY()>42,TRUE,FALSE) } |
________________________________________________________



I keep getting a Syntax Error on my field in the 3rd cell. I think the problem is that Word doesn't understand "TODAY()" like Excel does, but I don't know if there is any other way to calculate the days between two dates? My eternal gratitude to anyone who can figure out how to do this properly.

Answer:Date calculation using Word 2010 table/field Syntax Error

You will need to create a spreadsheet then "Link" that spreadsheet containing the calc cells.

Things to Remember When Linking
If you move the linked Excel file, you break the link. To fix this, you need to relink the file.
Double-click on the Excel data in your document to edit it: this opens the linked spreadsheet.
You can also edit the spreadsheet directly: the changes appear in your Word document once you save the Excel spreadsheet.
Regards,
GEWB

3 more replies
Relevance 55.76%

Hello,

I have been struggling with this for a couple of days.

Here's the scenario: I have 2 sets of data, one shows repeat calls for a list of customers, the other shows trouble reports for the same set of customers. I want to count how many times each of these customers called within 30 days of the original trouble report.

I have tried using a nested count Iif expression but I don't have a lot of experience with expressions and apparently am using it incorrectly. What I have tried is something like this:

=Count(IIf([Contact Date/Time],+30,1))

Any suggestions or ideas are welcome at this point. Thank you in advance!

Thanks,

sdl19
 

Answer:Access 2013 - Count only if date falls within 30 days of field from different table

I would create a 'groupby' query using the DateAdd function for criteria. If this is a report you should be able to link this query to the report query by acct number or something.
SQL looks like this example
SELECT Table1.Name2, Count(Table1.ID) AS NameCount
FROM Table1
WHERE (((Table1.Date1)>DateAdd('d',-30,Date())))
GROUP BY Table1.Name2;
 

1 more replies
Relevance 55.76%

Hi, I was kindly helped my AJ on this site to end up with

=SUMPRODUCT(((A7:A18)>=A6)*((A7:A18)<=B6)*(B7:B18))

for the folowing:
2 colums, 'A' with the year (currently as plain number) 'B' with a simple number. There are roughtly 5/8 entries for each year, from 1989 to 2008. I need to sum 'b' for a range of years, (say 1990 to 1995), I can do it for one year value but not more.

but the further problem I have is:
I have a list of 160 rows with the year being the key data field and selecting various ranges say 1995 to 2006.

I need to capture the data in a way that I need to keep historic info for years gone (2006,2007) but then alter the sheet (remove a row if no longer relevant) for current and future years.

I was thinking of having a final column with a "year removed field" and the main formula above being dependant on that for inclusion, make sense?
Many thanks
 

Answer:Excel 2003 - Selecting data within a date range with a further logic field?

8 more replies
Relevance 55.76%

I would like for my Access 2007 database to automatically record the date/time when the data in a SPECIFIC field is modified (not when any data in the record changes).

Here is a simplified explanation of my scenario. This database keeps track of cases in my office. A data entry form named "Cases" feeds a table named "Cases." The form includes text boxes that correspond to the fields in the table. Three of these are: "Case_Notes," "Case_Status," and "Date_Status_Change."

I would like for the "Date_Status_Change" field to automatically reflect the current date/time whenever the data in the "Case_Status" field changes. I do not want the date/time to change when information in the "Case_Notes" field is modified.

What code would accomplish this?

The following code will enter the date/time for a change anywhere in the record:

Private Sub Form_BeforeUpdate(Cancel As Integer)
Me![Date_Status_Change].Value = Now()
End Sub

But I want to limit it so that it dates changes ONLY in the ?Case_Status? field.
 

More replies
Relevance 55.35%

=RIGHT(YEAR(TODAY()),2)&TEXT(TODAY()-DATE(YEAR(TODAY()),1,0),"000")

This was working correctly for non leap years, but is a day ahead with calculated julian date...
JULIAN DATE FOR THE DATE OF: 09/08/2004 (Sept 8, 2004)
= 04251

My formula from above is calculating today's Julian Date as: 04252

JULIAN DATES ARE READ WITH THE FIRST 2 DIGITS REPRESENTING THE YEAR AND THE LAST 3 DIGITS REPRESENTING THE DAY OF THE YEAR.
Any idea what's wrong?
 

Answer:Excel 97 ~ Julian Date Calculation is a day ahead for Leap Year

10 more replies
Relevance 55.35%

This is very strange. I created a time tracking system for the company I work for. What they do is enter the time they start each task throughout the day and at the end of the week it all gets imported via VBA into an access database for the manager to review time cards. We had a need for people to be able to edit a record after importing so I set it up to do that. Problem is I found out when Excel sends the "start time" over to Access, it is sending over the time, for the year 1899. If I open Excel on my PC, click on Cell A1 and type 8:15 AM and hit enter, it shows in the bar at the top "8:15 AM". If i store that time in a variable in VBA and format it to show the year associated with that time it comes through as "12/30/1899 8:15 AM". This totally screws up my ability to edit records because when I programmed Excel to edit records it is searching based on a date/time to find the unique record because for John Doe and his time card he will have only one job starting at 8:15 AM on 4/9/12. So it looks up the record by the combination of the date and time. Problem is Excel is not storing a time as "today at this time" so lookups are failing because the year is wrong.

How come if I type in 8:15 AM in Excel it is not stored as 4/9/12 8:15 AM? The date is in a different cell on the sheet so if there is a way I can append the date with the time I guess that is what I will have to do. But as of yet I don't know how to do that.

Here is ... Read more

Answer:Excel date/time problem. Wrong year being displayed

9 more replies
Relevance 55.35%

I am trying to write a function that will determine the first day of our fiscal year for whatever date is inputed into it.

Our fiscal year always ends on the friday closest to 1/31.

I'm having trouble figuring out how to deal with january dates.

Any help would be greatly appreciated.
Code:

Function FiscalYearStart(dteDate As Date)
Dim dteNextFriday As Date
Dim dteLastFriday As Date
Dim x As Integer
Dim dteJanThirtyFirst As Date

'set as january thirty first of calendar year
dteJanThirtyFirst = "1/31/" & Format(dteDate, "yyyy")

'if 1/31 is a friday
If Weekday(dteJanThirtyFirst) = 6 Then

'use 1/31 and exit function
FiscalYearStart = dteJanThirtyFirst
Exit Function

Else: End If

'set as friday after january thirty first
dteNextFriday = DateAdd("d", 8 - Weekday(dteJanThirtyFirst, vbFriday), dteJanThirtyFirst)

'determine day of week for january thirty first
x = Weekday(dteJanThirtyFirst)

'if weekday is saturday
If x = 7 Then

'subtract 1
dteLastFriday = DateAdd("d", -1, dteJanThirtyFirst)

Else

'subtract 1 and the number of the weekday
dteLastFriday = DateAdd("d", -1 - x, dteJanThirtyFirst)

End If

'if last friday is less than next friday
If DateDiff("d", dteJanThirtyFirst, dteNextFriday) > DateDiff("d", dteLastFriday, dteJanThirtyFirst) Then

'use last friday and add 1 day to get start of fiscal year
FiscalYearStart = DateAdd("d&quo... Read more

Answer:Solved: Access 2007 VBA Fiscal Year Start Date

16 more replies
Relevance 55.35%

I know how to change this but I'm just curious why a fresh and clean install of Windows 7 put the year to 2010 even though I selected my correct timezone during the setup.

Answer:Clean Install; Date & time shows wrong year

Sounds like the motherboard battery needs to be replaced

6 more replies
Relevance 55.35%

Not sure if this is the right place to post my query but here goes.
When trying to troubleshoot a pesky Vista upgrade problem within various folders, including synchronizing the computer time, I stumbled upon the attached JavaRuntime script which shows a 'last accessed' date of 9/03/2073. Have attached a screen jpg screen dump.
Unless I'm rip van winkle, the last time I checked, currently it is 2009.
My questions are - where does this date come from and is this date component of 2073 a cause for concern.
Any advice appreciated. Many thanx. Lucee

Answer:JavaRuntime Script access date displays year as 2073

Hello lucee and welcome to TSF

Usually the last accessed time is generated by the PC using the current time set and stored in the CMOS (BIOS Settings),

If you are having issues setting the time or the CMOS is faulty and the time cannot be set then the last access time will be completely incorrect and far fetched,

What is the issue your trouble shooting to cause this java error?

Regards



Craig

2 more replies
Relevance 55.35%

I ran the steps in "Read & Run Me First Malware Removal Guide (incl. Spyware, Virus, Trojan, Hijacker)"

The problems I had was that the date/time went to the year 2036. This was after I turned off my anti virus program, Avast.

The issues were slow running programs, programs 'not responding' and no network ie; no access to NAS, no internet and no online activity. All the while the wifi icon was showing active in the bottom left of the screen.

Here are the reports from the Malware removal guide. Thank you in advance for any advice/assistance.
 

Answer:Date And Time Went To Year 2036 Causing Network Problems

Rerun RogueKiller and remove these items:

¤¤¤ Files : 2 ¤¤¤
[Tr.Gen0][File] C:\Users\Ben\AppData\Roaming\uTorrent\updates\3.4.8_42449\utorrentie.exe -> Found
[Tr.Gen0][File] C:\Users\Ben\AppData\Roaming\uTorrent\updates\3.4.9_42923\utorrentie.exe -> Found

Reboot and rescan with RogueKiller and attach the new log.
 

1 more replies
Relevance 55.35%

I need to set up a query that pulls information matching a certain date of the current month and year. I'm not sure about the syntax. Someone help please?
 

Answer:Solved: Query for specific date, current month and year.

16 more replies
Relevance 55.35%

Hello,
Firstly, let me apologise, I'm a complete Access noob & am trying to teach myself as I've got no one to help me in person.

Ok,
I'm trying to build a Time Sheet database that should record daily duties via an entry form:
"frm_Work_Hours"

This form updates an underlying table:
"Work_Hours"

The date field of the "Work_Hours" table is:
"Date_Worked"

However, workers get paid fortnightly and all their entitlements, allowances & overtime are calculated on these fortnightly periods. To be more specific, the workers are paid for a certain amount of overtime for each fortnight upfront & when they exceed that, then they are entitled to all excess time back in TIME OFF. So it's pretty important that each day's duties are assigned to the correct fortnight period so that their overtime & so-forth are calculated correctly.

Each fortnightly period is numbered according to year. For example, each year there are 26 fortnightly periods, so as an example today (3rd October 2013) falls in period 2013-19 (23rd September 2013 to 6th October 2013).

I've created a table called:
"tbl_Pay_Period"

Which has the following Fields:
"ID" (Auto-number)
"Period_Start" (date - the first day of each new fortnight period)
"Period_Number" (number - eg: 2013-19)

Back in the "Work_Hours" table, I inserted a new (Number) FIELD called:
"Pay_Period"

and set ... Read more

Answer:Solved: MS Access - How to get a field auto-update based on date entered in a form

9 more replies
Relevance 55.35%

we use outlook to view messages in the military. these messages are most likely refrenced by their date time group. in the message ( body of the email ) it will state the DTG.. example DTG: 291323Z Apr 10

i would like to make a field in my view so i can have the messages displaed by DTG. is this possible? if so how?

thanks
 

More replies