Computer Support Forum

Lenovo Vantage: Format of the date in battery "manufacture date" field

Question: Lenovo Vantage: Format of the date in battery "manufacture date" field

Hi! Does anyone know what is the format of the date in the field "(battery) Manufacture Date" informed by Lenovo Vantage (Hardware Configuration > Energy)? It seems not to follow Windows setting. In my case, it is set to Brazilian Portuguese DD/MM/YYYY, but there is not a leading "0" in the returned value (see attached image). Does it really disregard the Windows setting and presents it in a fixed format (maybe American English)? When was my battery manufactured (Oct. 07 or July 10)?Thanks in advance.

More replies
Relevance 100%
Preferred Solution: Lenovo Vantage: Format of the date in battery "manufacture date" field

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 (This link will automatically start a download of Reimage that you can save to your computer.)

Relevance 88.16%

In this first screenshot of Lenovo Vantage running under Windows 10 (64) on my X1 Yoga (1st generation), please notice where it says that I need to install Sierra Wireless EM7455 Software - 10 (64), version 7.47.4743.0105.  However, in the second screenshot, please notice where the Installation History shows that Sierra Wireless EM7455 Software - 10 (64), version 7.47.4743.0105 was successfully installed already. Everytime I boot up and run Lenovo Vantage to check for updates, it tells me that I need Sierra Wireless EM7455 Software - 10 (64), version 7.47.4743.0105 so I let it install it. Everytime I install it, the installation appears to be successful and my computer reboots, but then after rebooting, Lenovo Vantage again tells me that (1) I need it, (2) I already have it. This is crazy.  In the third screenshot (looking at Windows Device Manager) I see the Sierra Wireless EM7455 Qualcomm Snapdragon X7 LTE-A. The fourth screenshot shows that it is disabled.  I will enable this and then retry to install the updated. I'll report back in a second posting on this thread whehter it works.  (I would leave this posting open and finish it later, but I'm afraid it woud all be lost when I reboot).   

Answer:ENDLESS LOOP: Lenovo Vantage Tells Me To Update a Driver That Vantage Says Is Already Up to Date.

After enabling the driver in Windows Device Manager, then again trying to update, the update was successful. After another reboot, Lenovo Vantage no longer show that this needs to be updated.  I'm no programmer, but it seems to me that the Lenovo Vantage update program ought to be able to see whether a driver is disabled and to tell the user to enable it in order to allow successful of updating of the driver. My 2¢.

1 more replies
Relevance 82.36%

There are a lot of numbers on the N100 battery; do any of them relate to the manufacture date, or is there a way to find it out on the computer?Bonita

Answer:Battery manufacture date?

For Thinkpads notebooks there is usually, right out of the box, a VinkVantage software tool called Power Manager installed on the notebook, which among other valuable battery datas also shows up the the manufacturing date. I don't know if a Lenovo N200 comes up bundled with a similar tool, but you may took a look after the battery tools which do come along with your N200.Another way to find out the manufacture date via software is, to use a plain simple VBS script via the scripting host under windows. This works fine, as long as the Microsoft scripting host is as default installed with your windows OS and as long as your N200 has been setup to support the showup of it's battery data via WMI from Lenovo.Here is a VBS script which hopefully will show you among some other battery infos also the manufacture date. Just copy the contents of that script with the help of a texteditor into some meaningful file, like "batteryinfo.vbs" for example, and the doubleclick on that vbs-file you created inside the explorer. If all wents well, a little popup window will appear showing you after each click on it's Ok button some information of your battery.

ThinkPad T60/X32/600/770 · IBM IntelliStation · 3x IBM SpaceSaver II

2 more replies
Relevance 106.19%

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):
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 105.37%


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?


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 105.37%

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 ( 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 104.96%

Since installing Windows 10 - previously on Windows 7 - all dates in Excel have turned into the American date format i.e. previously 12/08/15 in a cell displayed as 12th August 2015. Now it displays correctly but the cell contents have changed, so, in previous example, the cell now contains 08/12/15. How can I put this right? I have gone into anything I could see re language and have ensured it is English (United Kingdom) but this hasn't made any difference.

Answer:Windows 10 has turned my British date format in Excel into the American date format. How can I get it to turn back?


10 more replies
Relevance 104.55%

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 104.55%


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.



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 104.14%

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:
="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?


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

7 more replies
Relevance 102.5%

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 98.4%

Greetings, and thanks in advance for your help..

Awhile back I formatted my Windows 10 PCs to show ddd dd-mmm-yyyy on my taskbar clock. This worked happily on my desktop and laptop for months, maybe even a year +

Now (probably starting in the past couple days, if not today), on one of those two PC's, this format will no longer display. It is Okay on the other PC.
What has changed that the taskbar clock space used to expand to fit the "short date" format, but now it will no longer expand - and instead just refuses to display the date at all. (NOTE: I've verified the issue by testing shorter formats -- short formats, like "ddd" show up correctly. Only if you request a longer format will the date not display - evidently because it is too long for the clock area. )

Additional Notes that may help:

* "Working" pc is running build 10586 PC with too small a clock space that won't expand -- Build 14393

*Other differences: Notification/Action center Icon is left of clock on the working PC - Right of clock on the non-working
Right- Clicking on task bar gives "properties" option on working PC -- But "Settings" option on the non-working

( I don't want to prejudice responses - but clearly the implication to me is that some recent OS update is most likely the culprit.)

Thank You

More replies
Relevance 98.4%

Greetings, and thanks in advance for your help..

Awhile back I formatted my Windows 10 PCs to show ddd dd-mmm-yyyy on my taskbar clock. This worked happily on my desktop and laptop for months, maybe even a year +

Now (probably starting in the past couple days, if not today), on one of those two PC's, this format will no longer display. It is Okay on the other PC.
What has changed that the taskbar clock space used to expand to fit the "short date" format, but now it will no longer expand - and instead just refuses to display the date at all. (NOTE: I've verified the issue by testing shorter formats -- short formats, like "ddd" show up correctly. Only if you request a longer format will the date not display - evidently because it is too long for the clock area. )

Additional Notes that may help:

* "Working" pc is running build 10586 PC with too small a clock space that won't expand -- Build 14393

*Other differences: Notification/Action center Icon is left of clock on the working PC - Right of clock on the non-working
Right- Clicking on task bar gives "properties" option on working PC -- But "Settings" option on the non-working

( I don't want to prejudice responses - but clearly the implication to me is that some recent OS update is most likely the culprit.)

Thank You

Answer:Taskbar Time / Date area quit expanding to fit desired date format

I had a similar problem which has been greatly ameliorated thanks to a kind respondant - see

1 more replies
Relevance 97.99%

Hi all,

I'm new to Windows 7 (Home Premium 32-bit) and I just can't figure out what's going on here! Basically I want my short date format to be dd/mm/yyyy (UK format) e.g. 05/11/2010, but when I key a date into Excel 2002 it is appearing as 05 11 2010. In Control Panel I have the short date format set to ddd dd/MM/yyyy and the example is shown as Fri 05/11/2010, but in Excel all the date formats are shown with space separators, e.g. 14 03 2001! I don't think it's an Excel problem though as in Windows Task Scheduler the dates are shown with spaces there e.g. '19:25 on Mon 01 11 2010'. The date by the clock though is shown correctly with slash separators!

I know in Windows XP you can select the date separator from a drop-down list, but this option seems to be absent in Windows 7. Under HKEY_CURRENT_USER\Control Panel\International in the registry, sDate was set to a space, but changing that to a slash (and rebooting) didn't fix the problem.

Does anyone have any ideas please what's wrong and how to fix it?


Answer:Date format using space as date separator rather than forward slash!


The option you're after is controlled from within Excel. If you right-click the cell(s) in question you can select 'format cells' and under 'Date' you can select the desired format.


9 more replies
Relevance 97.17%

Eg: In the below table (Excel) right now date is numeric want to convert them to DATE format Date of Birth Sex Date of diagnosis1 1/07/41 F 21.02.092 12/06/90 M 2/24/22614 1/07/62 M 11/02/095 1/07/48 F 26.05.096 1/07/39 F 11.02.097 1/07/76 F 2.05.098 1/07/60 F 30.05.099 1/07/80 F 1.03.0911 1/07/56 F 22.03.0914 1/07/65 F 22.02.0916 1/07/74 M 22.02.0917 1/07/67 F 24.03.0919 1/07/33 M 25.02.0920 1/07/45 F 21.03.09

Answer:Convert multiple date entries to DATE format

Whoever wrote the file couldn't even decide on a standard date format. Needs two routines. I prefer to normalize to yyyy/mm/dd.

7 more replies
Relevance 96.35%
Question: Manufacture date

I have a harddrive that was given to me without any software installed. How can I find the manufacture date of that's not listed anywhere on the outside.

Answer:Manufacture date

If there is no information on the HD (which there should be) you might be able to install it as a slave and use a program like Sandra to gain some info on it.

2 more replies
Relevance 95.94%

I forgot my new mobile password.Also i remove battery then time setting is now incorrect.I try 5-6 type to set password

Answer:I forgoet my scree lock password?Also i remove battery ow date setting is not current date?

hard reset your phone using following steps :-
1. Turn off your Windows Phone. Use power button to power off the phone.
2. Press and hold Volume down key and connect the charger to phone. You will see a big exclamation mark on the screen.
3. Press these keys one after another in the same sequence. Volume Up, Volume Down, Power, Volume Down.
4. You will see the phone reset and boot normally. You will see wheel gears working on the screen. It will take few minutes.
Your phone will be reset to factory settings and you need to set up the phone again.
Or try to reset phone's setting if it is connected to Wi-Fi or data is enable through your account.

more replies
Relevance 95.53%

Hello, I have a T500 that I am trying to find out the manufacture/build date. On the serial number sticker there is what appears to be a date but I don't know what format they are using.Because on the T61 models it is YY/MM so what is this? The number is 10/3/09 but is this March 9, 2010? Trying to make a list of the laptops from old to new in order to provide roll out plan for replacements and this will help. Thanks!

Answer:T500 Manufacture Date

You can enter the serial number into here:

6 more replies
Relevance 95.53%

Hello all.

I have a PC I would like to know the date when it was made, i forgot the command which could give me the date, i would appreciate if some one could give me the command.


Answer:How to find the date of manufacture of my PC

6 more replies
Relevance 95.53%

Do not understand how to get date of manufacture from serial# .. [Personal Information Removed].  I checked the forum.  Still quite confused.  Product # is: XU100UT  model is 8460w   I did discover it has expired warranty as of 2014..   thanks

View Solution.

Answer:Date of manufacture estimate help

Hi: Looking at the serial number, your notebook was made in 2011 in the 42nd week of the calendar year as shown in the 142 of the serial number. The 1 is the last digit of the year (2011) and the 42 is the week of manufacture.

2 more replies
Relevance 95.53%

I hope I'm in the right forum. I am looking at a used IBM A31 Thinkpad laptop w/Win XP Pro. How can I tell how old it is?

Answer:How do I find Date of Manufacture?

The serial/model number and the website of the manufacturer would be a place to start looking. In this case

3 more replies
Relevance 94.3%

I have bought a T520 to realize (through lenovo's website + thinkvantage toolbox) that the warranty started some 7 months ago, around the date that it was manufactured. I have called and spoken to the lenovo support in my city and I was reassured that as long as I have the warranty documents (which indicate a three year warranty) and the document that served as the proof of purchase (the receipt in my case) the thinkpad would be covered for three years of warranty. I have also registered the product (yesterday) hoping it would update the status of the warranty to what it should be. Although I have no doubt that the support lady whom I was in conctact with was telling the truth, I feel more comfortable with a laptop that I can just extend the warranty if I feel like it and not have the warranty extended seven months short of what it should be or having to carry the warranty document and the receipt when I travel. Even if I were to decide to sell the product at any time in the future, I would prefer to avoid a lengthy explanation to the potential buyer on why the warranty lookup has less time than it should. So, how do I fix this and make sure that my device has the proper warranty on the lenovo warranty database?


Go to Solution.

Answer:Warranty started on date of manufacture

Call up Lenovo Customer Service again, and ask the time of the warranty to be reset by faxing in the invoice.

3 more replies
Relevance 94.3%

I am planning to purchase a replacement motherboard to fix my Thinkpad E520 that won?t turn on due the faulty EEPROM issue. Is there a means of decoding the motherboard serial number to a manufacture date or is there another mark or number of the board that will tell me this ? TIA 

More replies
Relevance 94.3%

Hello! Where can I get a realese date of listed products? HP Compag nc6710 b T7500 (SCNU7381ZMN)HP Compag nc6720 (SCNU82019MM)HP 8470W (CNU30391F8)HP 6910p T7700 (CND80704MR)HP Compag nc6710 (CNU7512JZ3)HP ProBook 4530s (CNU1323NKW)HP F2U36EA (5CG402174M)HP 8470W (CNU30391F8) Thank you!


View Solution.

Answer:Manufacture or realese date of products

   hi  the realease date you can seen in warranty check the link bellow  Hope this helps, for any further queries reply to the post and feel free to join us again**Click the White Thumbs Up Button on the right to say Thanks**Make it easier for other people to find solutions by marking a Reply 'Accept as Solution' if it solves your problem.Thank You,

2 more replies
Relevance 94.3%

For those of you who are having significant issues with your W520 (sudden death, inability to wake from sleep, etc), please provide us with your date of purchase. I would like to know if the series is improving in quality as time wears on. Are early adopters the ones with most problems? Is the production process improving at all? If so, Lenovo should offer to replace machines from earlier in the manufacturing process since there are obviously inherent, permanent problems. As I said, please post your purchase date. I'm curious to see what becomes clear, if anything.

Answer:Problematic W520s - manufacture date?

Date of purchase: End of October 2011... Problems: SSS (Sudden Death Syndrome). Model: 4284-3WG

9 more replies
Relevance 94.3%

Hey all, I have two questions:

1. Does scanning for bad sectors on a HD in XP have a detrimental effect on the HD?

2. Also, anyone knows a way to see the HD manufacture date?


Answer:Bad sectors scan and HD manufacture date.

I dont know what kind of rives they are but the date should be on the drive itself. Western Digital has a program that will check for bad sectors as well. No it doesn hurt the HD.

1 more replies
Relevance 94.3%

how to tell date of manufacture of 1q524 NC701AA-ABA from serial number or how to look up?when were they first introduced? 

Answer:how to tell date of manufacture from serial number or how to...

dlkegarise See here for the release date. For the serial number the typical format is to have the 4th, 5th, and 6th characters to reference when the product was built.  The first character is the year date (Y) and the next two (WW), the week in that year it was made. CCSYWWZZZZ   Hope this helps you and anwsers your questions.  Regards.

I work for HP. When your problem has been solved, accept the solution by clicking the "Accept as Solution" button to help other members in the future!

5 more replies
Relevance 94.3%

One of my hard drives just failed after years of reliable service. A lot of valuable information was lost.

To avoid this in the future, it would be helpful to know just how old a drive is to know when it's time to be replaced.

Is there a program that can tell me when I drive was manufactured?

Answer:A program that shows Manufacture date?

Drive age doesn't really have much to do with 'drive failures'. Time in service increases the risk, but it's not a defining factor either.

The HDD should have a sticker on it showing date of manufacture. I don't know of a program.

1 more replies
Relevance 94.3%

Is there a website that lists the manufacture/release date of various brandname video cards ?

I want to know which video card is "newer" than the others and in what order (date wise) were the cards released. In this manner I can learn what model has the latest technology vs a previous model.

Surfing eBay and trying to decide which card is newer than the others is impossible and reviewing the ATI and NVidia websites doesn't help either (unless I've overlooked one of their webpages that provides the info I am seeking).

Can anyone help ?

Thanks !

More replies
Relevance 93.48%

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,

More replies
Relevance 93.48%

I bought an alienware laptop from a shop and it seems to work fine. What trouble me is when I enter the serial number in dell website, it says the country is unknown and the manufacture date is 01,0001. Could anyone tell me why is this happening?

Answer:Alienware Country and Manufacture Date unknown.

Only the seller can tell you what the history of the system is.

3 more replies
Relevance 93.48%

I'm looking for a replacement battery for this model ACER/Gateway  laptop:
S/n: #NXY14AA002***
Manufacture date 2012 09 06
Model #: Ne56r28u.  
Intel core 15
Thank you for your assistance! 
[edited for privacy - THIS IS A PUBLIC FORUM - please do not post personal or unique information such as but not limited to full names, email addresses, phone numbers, full serial numbers, etc.]

Answer:#NXY14AA002*** Manufacture date 2012 09 06 Ne56r28...

Amazon or Ebay have replacement batteries for your Ne56r28u gateway model for less than $25 with free shipping. Jack E/NJ
[subject line edited for privacy]

1 more replies
Relevance 93.48%

I ordered my new T400 in October, 2009, and recived almost three weeks later. Definitely, it took longer time than they promised me. Whatever, I got the laptop, finally.Now I have a question about the monitor. I used a software named EVEREST 5.30 ( to check the information of the hardware. Everything is okay except the monitor. It says the manufacture date is 45th week in 2006? Can you believe it, a monitor, potentially, made three years  ago for my new laptop??? I called lenovo, and they told me the LCD factory is probably using the same date for all monitors of this kind no matter when they're made. Can you believe it?They didn't have such complain before. If I can find different case for T400 with same kind monitor, they will accept my complain. Am I responsible to prove that or lenovo's? Anyway, we can do that, right? Hey, all T400 people, it's time to show our power! What's your manufacture date of the WXGA TFT LCD monitor? I will appreciated if you can post your LCD manufacture data as well as when you bought you laptop!  Many thanks to everyone.

Answer:The manufacture date of T400 WXGA TFT LCD monitor

Mine's a T500.. Purchased in Feb 09.  However, it has an LCD display which didn't exist too long before my order date... Field    ValueMonitor Properties    Monitor Name    Lenovo 154WX7-TLA2Monitor ID    LEN4057Manufacturer    154WX7-TLA2Monitor Type    15.4" LCD (WXGA)Manufacture Date    2008Serial Number    NoneMax. Visible Display Size    33 cm x 21 cm (15.4")Picture Aspect Ratio    16:10Maximum Resolution    1280 x 800Gamma    2.20DPMS Mode Support    Standby, Suspend, Active-Off

Thinkpad T500-2081 CTO | T9400 2.53GHz | 8 GB RAM | ATI HD3650 + Intel GM45 | 15.4" LED WXGA+ | Windows 10 | ATI Catalyst 13.1 (non-switchable)Thinkpad 390x | PII 333 | 256mb ram | NeoMagic 256AV | SVGA LCD | OS/2 v4.52

9 more replies
Relevance 93.48%

I am trying to find the manufacture date for pcs that I cannot physically look at, but have the service tag numbers.  Is there an link other than looking at the warranty.  That only shows the ship date, not manufacture date.  Thanks!

Answer:I need help Finding the manufacture date from the service tag number

The shipping date is essentially the same as the manufacturing date - bear in mind that in recent years, Dell systems are built under contract with ODMs (Foxconn, Pegatron, Wistron, etc).  Dell hasn't manufactured systems itself in years - so the ship date is all there is.

1 more replies
Relevance 92.66%

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 92.25%

what method that i can know when my computer was producted without checking manufacture website?and i heard that there is a program that can let us install RAM over 4GB On windows 32bits. Is it harmful to the computer?

Answer:Two ? PC Manufacture date & Program to expand mobo RAM size

What date are you looking for? Each individual component (motherboard, RAM, hard drive, etc) will have a different date of manufacture. If you have an OEM system, it will also have a date of assembly, possibly a label on the back of the case?Here's your memory patch:

3 more replies
Relevance 92.25%

Hey guys, I've just ordered a brend new X230 2325CT5.It has the older i5-3320M (Q2'12) ( and NOT a Win8 R-DVD.I could also get a X230 NZDAEGE with both the newer i5-3230M (Q1'13) ( and Win8, but I don't need any Windows.The specs of the two CPUs are nearly the same.What do you think is the better HARDWARE system?Why does Intel offer two marginally different processors?Is the 3230M better matured in comparision with the 3320M? And one last question: Does the CPU type allow conclusions on the manufacturing date of the ThinkPad? Cheers,Sebastian

Answer:X230: Differences i5-3230M and i5-3320M - Date of manufacture

These CPUs are not the same. 3320m supports at least 3 key technologies for many corporate users - TXT, vPro, VT-d.,64896As I see on Lenovo site laptops have some different specs, not only CPU models - 2325-AEG (NZDAEGE) has WWAN modem and Win7 Pro 64 instead of Win7 Standard in 2325CT5. Where did you find the mention of win8? On e-commerce shop sites?The date of the laptop manufacturing you can find on laptop packaging box or on the Lenovo site by its [laptop] serial number (as well as the detailed specification).

3 more replies
Relevance 91.84%

Hello allIs there anyway that I can type in a date like: 010199 and it then gets recognized as a date format and displays it as 01-01-1999 ?I can do it the other way around, if I type 01-01-1999 and have modified the date format to be ddmmyy, it works, but somehow it doesnt work the other way around.Any ideas for this? I know it is possible to make it happen by using another column and the number 010199 then gets converted to 01-01-1999, but I need this to be done automaticly (and with no macros)Thanks in advance/Jacob

Answer:Date format when typing the date?

Where are you typing this address - presumably in an Excel column?

6 more replies
Relevance 85.28%

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 85.28%

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 85.28%

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 85.28%
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 85.28%

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 84.05%

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

1 more replies
Relevance 84.05%

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?


Answer:MS Access - autofill date field

6 more replies
Relevance 84.05%

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 ?


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 84.05%

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 84.05%

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 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 84.05%

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 83.23%

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
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


exit celll with ctrl, shift, enter

1 more replies
Relevance 83.23%

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 83.23%

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 83.23%


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.


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


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'

Reuel Miller

1 more replies
Relevance 83.23%

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: and Answer. The way of learning.Dell Dimension 8300Intel Pentium 4 HT @ 3.20 GHz4 GB RAMNvidia Geforce FX5200

2 more replies
Relevance 83.23%

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!


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

16 more replies
Relevance 83.23%

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

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

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 83.23%

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 83.23%

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


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 83.23%

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 82.82%

Tech Support Guy System Info Utility version
OS Version: Microsoft Windows XP Home Edition, Service Pack 3, v.3264, 32 bit
Processor: Intel Pentium III Xeon processor, x86 Family 6 Model 23 Stepping 10
Processor Count: 2
RAM: 1981 Mb
Graphics Card: Intel(R) G41 Express Chipset, 256 Mb
Hard Drives: C: Total - 39989 MB, Free - 5211 MB; D: Total - 36294 MB, Free - 8687 MB;
Motherboard: ECS, G41T-M
Antivirus: PC Cleaner Pro, Updated: Yes, On-Demand Scanner: Disabled

Hi All
Im using the attached vba code and would like to use the "title" format function to show the date of the day in the User Form, is it possible and is there any help on this matter.

Thanks in advance

More replies
Relevance 82.41%


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 82.41%

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 82.41%

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 :

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 82.41%

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,


More replies
Relevance 82.41%

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;

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 82.41%

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 82.41%

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.


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 82.41%

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:

4 more replies
Relevance 82.41%

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 82.41%

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?

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

10 more replies
Relevance 82.41%

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 81.59%

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.MIKE

2 more replies
Relevance 81.59%

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

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 81.59%

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

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")
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 81.59%

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 81.59%

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 81.59%

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 81.18%

Windows repeatedly asks me to update with the little yellow exclamation mark in the tray but it always fails and then keeps asking over and over again. It's trying to update something I don't even use I think PowerPoint or something; I had the option off at one point for those programs so it wouldn't keep asking but then a message pops up saying are you sure you want to leave these off you might need them.

Any ideas on how to get past this?


Have a look at this link and see if it helps.

1 more replies
Relevance 80.77%

I am setting up a spreadsheet for the year and want to use it year over year. I have the cell set up with the date (1/1/2011) with a format of d so that it displays the date as Sat, 1/2/2011 - Sun, etc. Since I want to use this year after year with minimal work and I want to highlight the cells that are equal to Sat and Sun, how would I set up that formula. I tried the basic =A1="Sat" and without quotes but it just returns #NAME. I know working with dates in formulas is different but can't figure out what I need to use.

Answer:Solved: Excel 2007: conditional format when date displayed as format d

8 more replies
Relevance 80.77%

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 80.77%


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!



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 80.77%

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


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 80.77%

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.

3 more replies
Relevance 80.77%

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 79.95%

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.

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

This form updates an underlying table:

The date field of the "Work_Hours" table is:

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:

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:

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 79.95%

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?


More replies
Relevance 79.54%

I am working on creating a identifier for my data but when I enter in the formula into Excel 2010, the results are not appearing as I expected.Here is my formula: =A2&(LEFT(C2,3))&LEFT(B2,3)&LEFT(F2,1)where the cell A2 contains the date 11/23/1982However, in the results, it is appearing as 30278.The most frustrating part is I did the same formula in another spreadsheet and it worked as expected! The dates in that spreadsheet showed in the date format. Unfortunately, I did not save the other spreadsheet since that was just a draft to get the identifier.message edited by luthientinuviel

Answer:Formula is returning the text format instead of date format

Untested...=TEXT(A2,"m/d/y") & the rest of your stuffor=DATE(MONTH(A2)&"/"&DAY(A2)&"/"&YEAR(A2)) & the rest of your stuffClick Here Before Posting Data or VBA Code ---> How To Post Data or Code.message edited by DerbyDad03

6 more replies
Relevance 78.31%

in spread sheet if I format a cell as English uk date format dd/mm/yy I have to input data as mm/dd/yy and it shows it as uk format but if I input it as uk format it does not. All my older version spread sheets and accounts when opened with excel 10 give me wrong format. I have checked that the transition mormula boxes are unchecked

Answer:date format in excel 10 will not show uk format dd/mm/yy

It is not an Excel issue.I believe what you need to do is change the System Date Format, it is probably set for US and you need to change to UK.Look here for instructions on changing the System Date: is for Win 7, but Win 10 should be similar.MIKE edited by mmcconaghy

3 more replies
Relevance 78.31%

As above, I recently upgraded to XP from ME and since then the date format in the Received column of Outlook 2000 is in US format while in the Control Panel, everything is set correctly to the UK format.

Is there any way of forcing the issue in Outlook to make it behave as per the Control Panel?

Cheers all.

Answer:XP is on UK date format, Outlook 2000 is on US format

Hi Simes

After a cursory look through Outlook,
How does the time display in Outlook 2000,
Tools > Options > Calendar tab > Time Zone?

3 more replies