Over 1 million tech questions and answers.

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

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

Read other answers
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 http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)


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.  

Read other answers

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

A: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¢.

Read other 1 answers

Hi all,I have a new Yoga 920 and want to make sure that I have the most current drivers installed from the Lenovo site. Can I trust Lenovo Vantage that it checks for the most recent drivers/updates? Thanks,Marco

A:Can I trust Lenovo Vantage with keeping my drivers up to date?

I trust it BUT realize based on my experience it sometimes is 1-2 weeks behind what you see on the driver download page.  Which to me is ok in case there is an issue with the driver other people will most likley post issues on the forums about it first.

Read other 1 answers

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

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

Read other 16 answers

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.

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

Read other 8 answers


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

A:Access 2003 - Format field to Short Date

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

Read other 3 answers


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.



A: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?

Read other 3 answers

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?


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

Read other 7 answers

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.

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

Read other 7 answers

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

Read other answers

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?


A: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.


Read other 9 answers

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?


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

Hi Steven,
Thanks for the post!
When you set the Short date to ddd dd/MM/yyyy, the date by the clock is shown with slash, however, the date in Task Scheduler doesn’t show the slash. This behavior
is by design. When you double click the time and the trigger tab (for example) in task scheduler, the details are shown with slash.
When you change the Short date to dd/MM/yy, the date in the Task Scheduler and the clock become the same.
For the Excel date problems, I recommend you ask this question in
Office Forum.
The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and
other communities who read the forums regularly can either share their knowledge or learn from your interaction with us. 

Thanks for your understanding and cooperation!
Best Regards,
Miya Yao
 This posting is provided "AS IS" with no warranties, and confers no rights. | Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer
your question. This can be beneficial to other community members reading the thread.

Read other 5 answers

I want to format the date of Share Point list, I don't want to create Calculate formula column to format the date because. We cant change the existing date in Calculate formula date.
For Example
Existed date : 12/8/2018. here 
Calculate date : 12 Aug 2018
We cant edit the calculate date, but we can edit the Existed date.
While displaying the Calculate date it is disabling the Calculate date.
I want to change the date of Existed date and format into calculate  date.
"Here I have two question
1. Can we format the Existed date.
2. I know it is not possible to edit the Calculate date. But just asking any possibility is their to edit it."

Read other answers

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

A: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.

Read other 2 answers

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?

A: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 IBM.com?

Read other 3 answers

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.

A: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.

Read other 2 answers

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.


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

Read other 6 answers

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?

A: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.

Read other 1 answers

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.

A:Manufacture or realese date of products

   hi  the realease date you can seen in warranty check the link bellow  http://h20564.www2.hp.com/hpsc/wc/public/home  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,

Read other 2 answers

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 !

Read other answers

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

A: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!

Read other 5 answers

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?

A:Alienware Country and Manufacture Date unknown.

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

Read other 3 answers

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!

A: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.

Read other 1 answers

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,

Read other answers

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!

A:Update date field

Read other 6 answers

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.

A:Updating date field

Read other 6 answers

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.

A: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.

Read other 1 answers

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!

A: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.

Read other 9 answers

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?


A:MS Access - autofill date field

Read other 6 answers

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.


A: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
... ... ....

Read other 1 answers

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 ?


A: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.

Read other 3 answers

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 )

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


Read other 1 answers

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

Read other answers

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

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

Read other 1 answers

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!


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

Read other 16 answers


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

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

Read other 1 answers

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?

A:Solved: Stop Updating the Date Field

Read other 6 answers

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.

Read other answers

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.

A: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.

Read other 1 answers

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?

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

Read other 10 answers

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.


A: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.

Read other 2 answers

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.

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

Read other 7 answers

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

A: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?

Read other 2 answers

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.

A:Solved: Extrapolate Month from an Access date field

Read other 16 answers