Computer Support Forum

Excel 2010 UK Date to US Date

Question: Excel 2010 UK Date to US Date

I am frustrated with the following problem.
I need to convert the date to US formatting.
I receive a file in .csv format and the dates come as text and a normal date format all within the same column.

Example:

12/4/2012 23:16
12/4/2012 23:21
13/04/12 12:04 AM
13/04/12 12:52 AM
13/04/12 3:20 AM

The top 2, Excel reads as date. The bottom 3 excel reads as text...I need the bottom 3 to read as date.

Please HelP!!!

Relevance 100%
Preferred Solution: Excel 2010 UK Date to US Date

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

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

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

Answer: Excel 2010 UK Date to US Date

11 more replies
Relevance 82.36%

I'm working on a spreadsheet that lists monthly recurring expenses. I have one cell on the sheet listing the current date (using the "=Now()" formula), but I'd like to have the other cells change at certain times throughout the month.

For example, if one cell currently says "April-15", when the actual date reads "April-16", the respective cell would change to "June-15". This way, whenever the spreadsheet is viewed the next recurring payment date will be seen.

I know this is the wrong tool for something like this - I'm using SharePoint at the office with a calendar list with workflows that shoot off emails in a much better put together format - but this is just for home use and I'd like to keep it all in one document if possible.

Any ideas or suggestions would be greatly appreciated. Thanks in advance.
 

Answer:Excel 2010: Cell Date Change with Current Date

The way I read it was that you have fixed recurring payment dates, so you just want to know the next date based on the day today. Hope the attached might assist.
You need to list the payment dates somewhere and then the formula looks up the next date. You might want to look up today plus 1 (or something) to reflect the fact that if the next payment date is today, there's a good chance you'll not get any unplanned payments on that run.
 

1 more replies
Relevance 75.98%

I want to know an exel formual for the following - Any help would be great

Date Range
01/12/2013 - 03/14/2013

How many days from the date range 01/22/2013 - 02/21/2013 are in the above date range

So answer for the above would be 31

Thank you for your help!
 

Answer:Excel 2010 - Count # Of Days In A Date Range That Are Part of Another Date Range

Hi LucianC - try entering this info:
Start Date in A1
End Date in B1
=DateDif(A1,B1, "D") in C1
 

2 more replies
Relevance 96.76%

I have a spreadsheet where I need a cell to calculate the date (from a cell in column B) plus 14 days to get a due date, but leave the due date cell blank if there is nothing yet entered into column B. What formula should I use for this?

Answer:I need an If/then formula to add a date in excel 2010

Dates can be added just like numbers. Add 1, you've added a day; add 14, you've added 2 weeks.An IF statement can perform a calculation IF the logical_test argument is TRUE:=IF(B1="","",B1+14)If B1 is equal to nothing, return nothing, otherwise return B1+14.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

2 more replies
Relevance 96.76%

Hi everyoneThis might be an easy one for whoever knows itI have a number 8202014I need to format it as a date to show 08/20/14And the formula should also work for 10202014 to show 10/20/14I cant make a formula with left, mid, right that works correctly.Thanks in advance!!!

Answer:Formating to a date Excel 2010

If you know that the cell will only contain 7 or 8 digits, you don't need the second IF clause. The logical_test will either be TRUE for 7 digits or FALSE for 8, so a single IF function is all that you need.This version is shorter and slightly more efficient:=IF(LEN(E10)=7,DATE(RIGHT(E10,4),LEFT(E10,1),MID(E10,2,2)),DATE(RIGHT(E10,4),LEFT(E10,2),MID(E10,3,2)))Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

6 more replies
Relevance 95.94%

Hey guys,
I have a question about coding and setting an excel file to send emails. I am using an excel file to track maintenance work orders and I would like to get an email each day for each work order that is requested to be finished on that days date. I have attached the excel file I am using, and the column that is important is C, "Date Needed" - If that date is today's date, the cell turns red and I would also like to get email notification about it. A separate email for each cell that matches today's date.

Also, if possible, I would like for it to look at all the sheets, not just the current month's sheet. For example, if a work order was filed in July but wasn't needed until September, I would still like to get the email reminding me that it needs to be finished on xx date in September.

I have attached the excel file I want to use.

I have searched all over this forum and others and have found many posts similar to this, but I am not a great manipulator of code, so I cannot get any of the other solutions to work.

Any help would be greatly appreciated, thanks!
 

Answer:Solved: Using Excel 07 to Send Emails When Date in Column = Today's Date

16 more replies
Relevance 95.53%

All my Excel 2010 files on Win 7 64 bits have had their date formats changed from yy-mm-dd to yyyy-mm-dd; formats that were previously yyyy-mm-dd have been left unchanged.This is very time consuming as I have to do format cells changes on every field of every tab of every file affected; because of the space factor, I need to use the shorter format.I have woken up after spending hours on manual format cells changes and have thought of checking if my short date format in regional date formats had been changed...sure enough; I have made the correction and everything is back to normal.The change must have been made by Windows update between 13/3/22 and 13/3/25; the only time I change formats is when I install a new version of Office (October 2010 in my case).

Answer:excel 2010 loses date format

Since everything is back to normal, I assume this is just an FYI, correct? I didn't want to leave your post as "Unanswered" so I am posting this response.DerbyDad03Office Forum ModeratorClick Here Before Posting Data or VBA Code ---> How To Post Data or Code.

3 more replies
Relevance 95.53%

I have an excel spreadsheet with a date column. The column format is *3/14/2001. I enter 08/01/2011. The formula bar reads 8/1/2011. The cell reads 40756. If I put the cursor in the formula bar the cell reads 8/1/2011. Place the cursor any place else cell revers to 40756. How can I get the date to display as a date in the cell.

Answer:excel 2010 date format problem

One of your options is messed up:Click on the Office Button in the upper left cornerClick on Excel Options, down the bottom of pop upClick on AdvancedScroll down to the section that reads: Display Options for this Worksheet:UN-Check the box that read: Show Formulas instead of their calculated results.Click OKThat should correct your problem.MIKEhttp://www.skeptic.com/

3 more replies
Relevance 95.53%

I am trying to keep track of due dates on my spreadsheets. I have some dates that expire annually and the others biennially.

Answer:how can i track a due date on ms excel 2010 spreadsheet

You'll need to explain what you mean by "keep track of due dates".For example, are you asking to have them turn a specific color when they get within a month of coming due? Are you asking for pop up messages when a due date is imminent?We need details, my friend, details.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

7 more replies
Relevance 95.53%

in excel when i type a date ie..06/10 it shows as 9/1/1901 i have tried changing the format cell but that doesnt fix it. is there another format or formula i need to find to fix this

Answer:excel 2010 help needed for date format

Where are you located, US or Europe/Asia?Is your default date: 12/31/2011 Month Day Year ?or 31/12/2011 Day Month Year ?I do not know how you are getting 9/1/1901 from entering 06/10,but you can try a Custom Format and see how that works.Custom FormatRight click on the cell with your DateSelect Format CellsSelect Custom, at the bottom of the popup windowIn the small input box, under the word Type:delete what ever is in the box and enter:MM/DD for Month Day type of dateorDD/MM for Day Month type of dateClick OKAs long as your cell contained an actual date then you should see it change.MIKEhttp://www.skeptic.com/

2 more replies
Relevance 95.53%

Hi

I hope somebody can help.

I am attempting to set-up a spreadsheet to workout calculations based on working days (not Saturday & Sunday) only.

I can work it out using Saturday & Sunday, how do I exclude weekends from the calculation?

Thanks

Dave
 

Answer:Solved: Excel 2010 - date Calculations

use networkdays()
or
workdays()

see
http://office.microsoft.com/en-gb/excel-help/networkdays-HP005209190.aspx

http://office.microsoft.com/en-gb/excel-help/workday-HP005209339.aspx
 

3 more replies
Relevance 95.53%

I have a date tab with dates (Column A "dd/mm/yyyy", Column B "MMM-yy" and Column C "yyyy-yy" [financial year]).I work in a hospital. I have a list of surgeries with the date ("dd/mm/yyyy") they were performed. I have a Vlookup to obtain the "MMM-yy" data (for my monthly pivot tables) as follows:=IF(ISNA(VLOOKUP($B39,Dates,2,0)),"",VLOOKUP($B39,Dates,2,0))I came across an error in my source tab - all dates in March 2017 had "MAR-16" in Column B. I changed these, manually, to "'MAR-17".The Vlookup continues to work every single month but for MAR-17.When formatted as General (as all the others are), it returns "42795". When I change it to Custom format "mmm-yy" (which none of the others, which work fine, are), it returns "Mar-17" but in the pivot table comes up as "1-Mar-2017" whereas all the others are "FEB-17" etc).Any help would be great.Thanks in advance!

Answer:MS Excel 2010 Vlookup Date Problem

I'm not near Excel right now to try anything, but my guess is that all the working "dates" are not actual dates as far as Excel is concerned. My guess is that they are actually text, which may explain why they don't show up in your pivot table with the "day" portion or display the serial number like the Mar-17 cells do.Excel can be weird when it comes to dates/text, especially if the "dates" were imported from another source. They often come over as text and is can be troublesome to convert them to dates that Excel will recognize. In your case, you may have the opposite problem. I think you have to change your Mar-17 to Text in order for your VLOOKUP to work like the others. That can also be troublesome because Excel will often be reluctant to give up a Date format once it is set. You could try adding a single quote before a few of your Mar-17 entries to force them to Text and see how Excel handles them.Like I said...just a guess.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

3 more replies
Relevance 95.53%

Excel 2010 IF stmt based on DATE value: I have a simple employee expense report that calculates mileage in cell D12 based on the date in cell B12. My formulas is as follows: =IF($B12>=DATE(2011,1,7),$D12*0.555,$D12*0.51). All mileage incurred equal to or greater than 07/01/11 should be calculated at $0.555 cents while all else should be calculated at $0.51 cents. I believe it's as simple as Excel not recognizing my DATE(2011,1,7), as the date 07/01/11... Help?

Answer:Excel 2010 IF stmt based on DATE value

You are right, Excel will not recognize DATE(2011,1,7) as 07/01/2011 sinceDATE(2011,1,7) means January 1, not July 7.The syntax is: DATE(year,month,day)=DATE(2011,1,7)=DATEVALUE("1/7/2011") will return TRUE.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

2 more replies
Relevance 95.53%

Hello there, I have been looking a while now without much luck. It may be that I don't quite know the proper search terms but my problem is this:the problem concerns apartments, their occupancy, and their last remodel.I am looking to create a nested function that will return "Need To Remodel" as the result if 'F14' is is unoccupied and was last remodeled before 2005 ('G14'). Otherwise, the function should return "No Change" as the result.Column F has yes/no values concerning whether it is occupiedColumn G has a date (2004,2008,2001, etc) giving its last remodel Any help would be greatly appreciated

Answer:Excel 2010: IF/AND nested function w/ a date

re: Column G has a date (2004,2008,2001, etc) 2004, 2008, 2001 are not dates. If that is all that is in the cell, it's just a number according to Excel.=IF(AND(F14="No", G14<2005), "Need To Remodel", "No Change")Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

9 more replies
Relevance 95.53%

Somehow the date on one of my old Excel files has turned from 1999-10-04 (i.e. October 4, 1999) to 4617-04-11. How can I change all the rest of the incorrect dates back to what they should be? This is the only date that I can confirm. And I have no idea what the rest of all the dates should be on this spreadsheet. TIA.

Answer:Excel date problem - to convert incorrect date to original

I have no idea what the rest of all the dates should be on this spreadsheetThen how do you purpose to change them, when you don't know what year they are supposed to be?Somehow the date on one of my old Excel filesAny Macros running that may have in some way impacted the dates?How is the data stored? As Text or as a Date?MIKEhttp://www.skeptic.com/

5 more replies
Relevance 94.71%

In excel 2010 new sheet, I would like to enter order number on column A1 then column B2 will show time and date automatically then after entered data then A1 and B1 should locked the cell and won't change anymore. Is this possible to do it?Thanks

Answer:Auto create time and date in Excel 2010

If B2 will be empty the first time an order number is entered, then this code will enter the date and time once and will not change for subsequent changes to A2.If there will already be something in B2, then things get more difficult and I will need more specifics.(BTW...I am assuming the A2 and B2 are just examples. The code actually applies to the entire Columns A & B)
Private Sub Worksheet_Change(ByVal Target As Range)

'Determine if change was made to Column A
'and respective row in Column B is empty
If Target.Column = 1 And Cells(Target.Row, 2) = "" Then

'Unprotect Sheet, Enter Date/Time in Column B, Protect sheet
ActiveSheet.Unprotect Password:="zzzzz"
Cells(Target.Row, 2) = Now
ActiveSheet.Protect Password:="zzzzz"
End If
End SubClick Here Before Posting Data or VBA Code ---> How To Post Data or Code.

8 more replies
Relevance 94.71%

I'm trying to create a formula that will input the maturity date of a particular loan. The spreadsheet contains the interest (fixed rate), the monthly payments, and the current balance of the loan (see below).

The current date will be displayed at the top in a separate cell that we can use to base the maturity date off of, but I guess I just don't understand how to do the math to begin with.

Eventually, I'd like to add a separate sheet with the amortization schedule which could easily just be referenced on this sheet instead of doing all the math here, but if I can understand the math first, I can take it from there.

Any ideas? Thanks in advance.
 

Answer:Excel 2010: Loan Interest End Date Calculation

Hi, I was just curious to see how many Excel posts have gone unanserede and cam accross your post.

I'm not in to economics or finacila calculations, but Excel does have a function named EDATE()
description and syntax is described in the link below:
http://office.microsoft.com/en-001/excel-help/edate-HP005209073.aspx

Amorization table in ExceL:
https://www.google.com/?hl=en&gws_rd=ssl#hl=en&q=amortization function excel 2010

Maybe this will help you along.
 

1 more replies
Relevance 94.71%

I have a simple spreadsheet TBH for which two columns of data have date fields:

End date and Reminder date

I would like to set a conditional format using the icon sets for the reminder date as follows:

1) If the reminder date is less than 90 but greater than 60 days of the end date then show me a green icon

2) If the reminder date is less than 60 but greater than 30 days of the end date then show me a amber icon

2) If the reminder date is 30 days or less than end date then show me a red icon

I have come across ways of using today and dates in advance but not before...please can someone help me.?
 

Answer:Conditional Formatting for a date range in Excel 2010

Hi

To use the icon set you'll need to calculate the differences in a new column in the spreadsheet and then apply the conditional formatting to the values in that new column. So if your Due dates are a Col A and your reminder dates are in Col B in Col C use =A2-B2 and drag this down to the end of the list. Then apply the conditional format to Col C.

Here is an example spreadsheet.
 

1 more replies
Relevance 94.71%

So I have this excel spreadsheet and an example of it basically looks like this:

Project Phase Person Capacity Start Date End Date
A Design 1 25% 1/15 3/16
A Model 1 25% 3/17 5/11
A Design 2 25% 1/15 3/16
A Model 2 25% 3/17 5/11

I'm looking to track a monthly outlook of capacity % over time for each person (in a pivot table), but I'm unable to get it exactly the way it should be. Essentially I would like it to look like this below:

Dates
Person Jan Feb Mar Apr May
1 25% 25% 25% 25% 25%
2 25% 25% 25%

(Sorry, the text keeps left aligning so person 2 should actually have 25% under Mar, Apr, and May.)

Is this even possible, either in a pivot table, or even using formulas?
 

Answer:Excel 2007 - Start Date and End date question

16 more replies
Relevance 94.71%

I am looking to set up a macro or formula that basically inserts the current time when a cell is filled SO:

when a2:a100 is populated with any thing then the corresponding C cell will be populated with the time.

AND

when e2:e1000 is populated wiith anything then the corresponding D Cell will be populated.

Currently I am using this macro.
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count > 1 Then Exit Sub
If Not Intersect(Target, Range("A6:A100")) Is Nothing Then
With Target(1, 4)
.Value = Time
.EntireColumn.AutoFit
End With
End If
End Sub

which works great for the A and C cells

but it does not work for the other one.. how do i add and modify this so all my needs are met.
I need another 2 sets of 2 macros accross the sheet for time entry.
 

Answer:Excel date auto populate date/time

11 more replies
Relevance 94.71%

So I have this excel spreadsheet and an example of it basically looks like this:
Project Phase Person Capacity Start Date End Date
A Design 1 25% 1/15 3/16
A Model 1 25% 3/17 5/11
A Design 2 25% 1/15 3/16
A Model 2 25% 3/17 5/11

I'm looking to track a monthly outlook of capacity % over time for each person (in a pivot table), but I'm unable to get it exactly the way it should be. Essentially I would like it to look like this below:

Dates
Person Jan Feb Mar Apr May
1 25% 25% 25% 25% 25%
2 25% 25% 25%

Is this even possible, either in a pivot table, or even using formulas?
 

Answer:Excel 2007 - Start Date and End Date question

You should have posted that in "Business Applications" here: http://forums.techguy.org/16-business-applications/
 

3 more replies
Relevance 94.71%

Hello,

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

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

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

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

Thanks

Daniel
 

Answer:Exported date field not recognized as date in Excel

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

3 more replies
Relevance 94.71%

I have a file that lists a Julian date of, for instance, 37573. How do I convert that into something like 11/06/02?

Thanks in advance!
 

Answer:Julian Date--How to convert to calendar date in Excel

That's not a Julian date, Beth.

That is actually a date value that Excel provides.

That's how many days it's been since 1/1/1900.

To change it to a real date, you should be able to select that cell or entire column, hit Format-Cell, Number tab, and choose Date, and then any one of the date formats.

Julian dates are what numbered day of the year. For instance, January 3, 2002 would be 3.

Learn lots about dates and times in Excel:

http://www.cpearson.com/excel/datetime.htm

Be prepared to be there for a while.

Happy Thanksgiving!
 

2 more replies
Relevance 94.71%

Excel 2013 and Windows 10 Pro

Today is May-14

Date format is set to show: Mar-16
Pressing Ctrl+; shows: 05 14 2016 in the cell
and it converts to: May-16 after I exit that cell.

Any ideas as to how to fix this or why it adds 2 days to the date?

I don't do much on computer now because of health but when I do and there is a problem, I know some of the experts are here.

Thank you in advance, Ron
 

Answer:Excel Date shortcut posts proper date and then changes

Hey Ron,

This should be a fairly simple one. I'd hazard a guess and say the May-16 is the month and year rather than the month and day.
If you click the format drop down as shown below, and click the last option for more formatting options.

In the box that pops up, navigate to Custom using the left hand panel to navigate.
Here you can make your own (or use a preset if you wish) format to suit your needs.

Here is a quick key to help you get by:
dd = Day in Number format
ddd = Day in Short text
dddd = Day in Long text
mm = Month in Number format
mmm = Month in Short text
mmmm = Month in Long text
yy = year in 2 digits
yyyy = year in 4 digits

You can separate these with pretty much whatever you want.
All of this data is input into the "Type" field as shown in the picture above.

See the picture for an example, Ironically it is May 16th today so it will appear the same as your issue does, but rest assured, as long as you have those D's in there, it will display the day!

Best of luck,
Let us know how you get on,

Xsage
 

1 more replies
Relevance 94.71%

Hello. I have a cell on my spread sheet which calculates an earliest date due. The cell references other cells to achieve this and looks like this '=C51+(F8*7)' where cell C51 is a date field in the format DD/MM/CCYY and contains the date 26/12/2015. And cell F8 is a number field which contains the value '4'. This value '4' is indicating a number of weeks. So the calculation (F8*7) gets me the number of days and I then add those days to the date in cell C51 to get 23/01/2016.I want this cell to output the current date if the calculation above results in a date that is in the past. Can anyone tell me if there is a simple way to achieve this? Thank you.

Answer:Excel: Substitute a past date with the current date

If I understand you correctly, this should get you what you want:=IF("your calculation"< TODAY(),TODAY(),"your calculation")However, the TODAY() will update every day to always show the current date, assuming "your calculation" results in a date that is in the past.In other words, it will not lock in the first date it calculates. It will always display "today's" date.Is that what you want to see?One other issue: As explained at the link below, the TODAY() function is "volatile". That means that is will recalculate every time the sheet calculates, even if none of the arguments have changed. A large number of volatile functions can slow a worksheet down.https://msdn.microsoft.com/en-us/li...Volatile and Non-Volatile Functions

Excel supports the concept of a volatile function, that is,
one whose value cannot be assumed to be the same from one
moment to the next even if none of its arguments (if it
takes any) has changed. Excel reevaluates cells that contain
volatile functions, together with all dependents, every time
that it recalculates. For this reason, too much reliance on
volatile functions can make recalculation times slow. Use them
sparingly.

The following Excel functions are volatile:

NOW
TODAY
RAND
OFFSET
INDIRECT
INFO (depending on its arguments)
CELL (depending on its arguments)Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

4 more replies
Relevance 94.71%

I received a .csv file from a company with a date field that looks like this: Tue Jan 03 12:12:20 PST 2012I have tried using the Data Type options to change this to a mm/dd/yyyy format but it will not apply. I tried converting it to a serial number using*mm/dd/yyyy and it will not work ~ nothing happens. I tried using a DATEVALUE formula but keep getting a #VALUE error .. I obviously don't know how to lay it out. Can anyone give me the DATEVALUE formula for this example? I am not sure what "right", "left" or "mid" represent or how to count the value placements. THANKS!!!

Answer:How do I convert a complex date to a simple date in Excel?!?

Try this:With your date in cell A1,First, format cell B1 as a DATE fieldRight click your mouse, select Format Cell, Select Number Tab,select Date, choose the date format you want.Next, in cell B1 enter the formula:=DATEVALUE(MID(A1,5,3)&" "&MID(A1,9,2)&", "&RIGHT(A1,4))That should give you what your looking for.MIKEhttp://www.skeptic.com/

3 more replies
Relevance 94.71%

Hello, I have spreadsheet with a number of dates and times ie (11/19/07 8:57 AM) in column A and data going along with each of these dates and times from columns B-CK. I am trying to limit the list to show the information that is for all times after 2:45PM. The problem is I cannot sort by time and the dates attached to all the times span from 2004-2007. Please help!
 

Answer:Stripping the date portion of date/time in excel

7 more replies
Relevance 93.48%

Help

I'm mail merging with Word a huge contract document and need to put in the phrase 'this contract is made on the [seventeenth] day of [April] [2010]'. Even in a custom format I'm struggling. When the contracts are printed off they need to be 'today's date' ie the day they are printed.
Thanks
 

More replies
Relevance 93.48%

Yo folks,

Annoying little thing in excel,
I want to show the date exactly like this: 00-00-0000 (08-03-2012)(dd-mm-yyyy)
Instead excel removes the zero's like this: 0-0-0000 (8-3-2012) (d-m-yyyy)

Is it possible to keep the zero's?

Thanks in advanced,

Answer:Excel 2010 question: Date 00-00-0000 (08-03-2012)(dd-mm-yyyy)

what i think you want is to format the cells with a custom format...

Use dd/mm/yyyy for the Type

edit: use dd-mm-yyyy for the Type

2 more replies
Relevance 93.48%

I haven't been able to quite get my functions right on this one and am hoping for some guru help.

I have a spreadsheet with dates in Column A (Contract Received) and Column C (Contract Filed). Not every cell has a date in one or both fields, as it is a tracking tool for work in progress. However, a contract must be Received before it can be Filed, so C will (er,should) never be blank if A is populated. I want to know the number of days lapsed between date Received and date Filed, and if date Filed is null, then number of days from Received to today's date. If the contract has not been Received, then no calculation should be performed. In spite of requests not to, users sometimes put text notes in these fields, so would be nice to ignore text. At bottom of column, I need to get an average of the time lapse on all filings to track productivity. This doesn't sound so difficult to me, but somehow I haven't gotten it quite right in the last two hours and it's time to ask an expert. Thanks in advance for your help!

- k
 

Answer:Excel 2010 Date Calc Formula, Ignore Blanks

Hi k, welcome to TSG.

Try this and let us know if it gets you close to what you need:

=IF(ISNUMBER(A1),IF(ISNUMBER(C1),C1-A1,TODAY()-A1),"")

It basically starts with column A and determines whether there's a number there (a date, as opposed to text or blank). If not, it doesn't do anything, but if so, then it does the same thing with column C. If C has a number (date) then it subtracts A from C. If not, it subtracts today's date from A.

Let me know if I've misunderstood the question.
 

1 more replies
Relevance 93.48%

I have a chart whose title I would like to read "Between (Date 1) and (Date 2)" The Date 1 field, AD4, and the Date 2 field, AF4, changes depending on what date range I want to use for data. I looked on a previous post, http://forums.techguy.org/business-applications/601180-dynamic-static-content-excel-chart.html, which led me to put in the formula bar: ="Between " &$AD$4 "And " &$AF$4. Excel gave me an error, so for now I'm just trying: ="Between " %$AD$4. When I do this, the field displays the date as a serial number (ex. 40544) instead of the date. Any ideas on how to fix this and be able to put both the before and after in the title?

I'm running Excel 2010 on Windows XP.

Thanks,
Dobber92
 

Answer:Solved: Excel 2010 Dynamic Chart Title Date

What happens if you link the title to a cell containing:

="For "&TEXT(AD4,"dd-mm-yyyy")

?

NB: this response is to your pre-edit question.
 

3 more replies
Relevance 92.66%

Does anyone know how to convert a date entry from Unix format to Gregorian calendar format?

I have a long table with Unix values for date and want to plot a count of row entries within a certain date range...

Any ideas?
 

Answer:Excel: Unix date to gregorian date

Also... how do I count the number of occurrences of similar entries in a column... i.e.

1
1
1
2
2
3
3
3
3
4
4

I want to be able to count the number of occurrences of 1, then the number of occurrences of 2 etc etc
 

2 more replies
Relevance 91.43%

Hi, I've got something that keeps going wrong.\
I have a large file which I use at work to register and plan my colleague's tasks and resgiter (outside our regular vacation/sick/abscence, etc.) the different calls they are working on allocating this. But that works, that's not the issue.
I have a sheet named "Medewerkers", yes it's Dutch for Employees of Colleagues.

I extracted and stripped this portion. (June 16: removed this attachment, correct attachment in final post)

On this sheet double clicking in Column A on the name will open a userform to edit this one or if you double click the first empty row below it you get a blank form to enter the data.
Since I regularly ran into problems useing the ....ocx calendar picker I wrote my own date picker and it works. Using son supporting code I found the funtion GetDateInLocalFormat() does it's job.

But now the issue:

The person on the sheet has as starting date 01-03-2012 (in Dutch format this March 1, 2012) and ends August 2012

On my system and at work The date pickers selects it correctly, show is and the userfrom shows it as 01-03-2012 but when I press 'Vastleggen" (Commit) the date is saved as 03-01-2012 which in Dutch January 3, 2012 when I double click again the datpicker shows the default data as January 3, 2012.

The cell's format is dd-mm-yyyy;@ the system's settings are for code 31 which is Dutch and I have pasted screen shost of the settings that show this.

I... Read more

Answer:Solved: Excel (2010) Date format issue dd-mm-yyyy and I can't find the solution!

I changed my code a littel and instead of passing the date in local format I pass it as a serial date and then there is no doubt and the result is correct. But if somebody can offer a better solution, I'm all eyes and ears, and ... maybe it will help others who struggel with date values and the international settings
 

2 more replies
Relevance 89.38%

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?

Freeeeeeeeeeeeedom!

10 more replies
Relevance 84.05%

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

____________________________

____________________________
Developers
Not Available

Version
1.0.0.2

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

Last Used
Not Available

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

Mature
This file was released 4 years 8 months ago.

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

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

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

11 more replies
Relevance 82.41%

I need to add 5 units to a sum every month. I want to be able to do this via functions.
In other words, today is November 8th. On December 8th, I want my cell increase by 5, and on January 8th, I want my cell to increase by another five, and so on...
Thank you!
 

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?
 

Answer:Windows Update...date...date...date....

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

http://support.microsoft.com/kb/910339/en-us
 

1 more replies
Relevance 77.9%

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

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

On Error GoTo Handle_err

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

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

... Read more

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

16 more replies
Relevance 77.9%

I got a Refurbished Dell Latitude D600 Laptop from ebay yesterday on Tuesday, September 26th 2017, It had Intel Pentium M (Non-Centrino) and Windows XP Pro SP3, but when i boot it up, it resets to The Default BIOS Date, can someone help me?

Answer:Dell Latitude D600 Current Date Resets to The Default BIOS Date

The coin cell battery on the motherboard that keeps time while the system is powered off is probably dead.  Not too surprising given that the D600 is about 15 years old at this point.  If you open the system up, it should be easy to find, so just note the type of battery, e.g. CR2032, and then buy that type of battery at any grocery/convenience store.  Should only be about $2-3.

2 more replies
Relevance 77.9%

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 https://www.tenforums.com/installatio...-new-post.html

1 more replies
Relevance 77.9%

Help! I am using a Seagate Central 4TB NAS drive attached to my router via Ethernet. It has been working fine so far for all kinds of file activities. But whenever I modify a file in one of its folders, the creation date for the file also updates and is
changed to the same time as the new modified date.
Maybe relevant details:
I can move/copy folders to the drive and they maintain their created dates.
It happens for both a private user share on the NAS and for the Public share on it.
It happens for at least image files and text files.
I am able to edit files across two computers on the network just fine, the create date stays the same.
This happens from a new Windows 10 machine and Vista machine both.
I notice sometimes the date created seems to stay same until I access the file the next time.
I can't update the NAS firmware because of error.

If it could be a permissions problem, I have been unable to change it from:
Everyone: Special Permissions only
nobody (Unix Group\nobody): Special Permissions only
nogroup (Unix Group\nogroup): Special Permissions only
(Those were there automatically, they are not something I manually put there. I get "Access is denied" whenever try to add permissions or change ownership.)

I have Googled many phrases of this problem far and wide and come up with nothing. I really need to save the original create date because that's how I sort them in programs like Windows Photo Gallery or Picasa. Does anyone know what's goin... Read more

More replies
Relevance 77.9%

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

Searching for files modified in a specified date range (of the past 3 days) gets a search result list titled "date modified", and with the column heading "Date Modified" but the date listed against a file modified today is wrong. The date displayed matches the file creation date & is within the specified range ... but how do I know what the Search is doing?

Can't trust it... !

Answer:File search (by date range) displays incorrect Mod Date in results

That is very strange. Bump for a possible solution, since I can't think of one off the top of my head.

1 more replies
Relevance 77.9%

Hello.
I'd like to see Long Date and Long Time in my System Tray instead of Short Date and Short Time. 
But due to some restrictions connected with my work I can not modify Short Date & Short Time to look how I want them to look in System Tray.
So basically I need Windows to show what is set as Long Date & Long Time in System Tray instead of showing Short ones.

Is it possible? Maybe some registry tweaks?

Answer:How to display Long Date in System Tray (without modifying Short Date)?

Hi,
There is no workaround to display the Long Date in taskbar without modifying the Short Date parameter.Ivan-Liu
TechNet Community Support

8 more replies
Relevance 77.9%

It looks like the 31 March deadline for the latest Edge promotions is the date of invoice rather than the date of order. Given Lenovo's reported long build time and slow delivery (= late invoice), I suspect that ording now from the Lenovo web site will see an invoice date outside the qualifying period. Even a dealer who says he can 'get one in' may not deliver and invoice until April or beyond. I think the only option is to find a dealer who unequivocally has current stock.Can anyone shed any light on the likely position. I do, though, wonder about trying to take advantage of Lenovo Cashback at all, given the horror stories reported here.

Answer:Edge 31 March promotion deadline - order date or invoice date?

My experience with cashback is a deathly silence from Lenovo to emails asking for progress on the cash or even recognition that there has been a registration for cashback...Currently considering giving Lenovo some publicity on the matter.Unless you have a lot of time to possibly get no where I would steer clear of the alleged cashback scheme...

1 more replies
Relevance 77.9%

The title is self-explanatory. So far, I found a software that is able to change this called 'Attribute Changer' but it only changes the date modified in the folder and, when you go into the actual word application > file > info, the date created and modified are not changed. Any help would be greatly appreciated! Thank you!
 

Answer:Changing 'date created' and 'date modified' in Microsoft Word 2013

7 more replies
Relevance 77.9%

After running a large update of windows on May 18 I found that ALL my files in ALL my folders are showing a Date Modified of May 18 2013. Can't find a similar report of this problem. Any ideas?
Using Windows 7 Professional 64-bit

Answer:File Date Modified reset to today's date after windows Udate

Would this help? enter link description here

1 more replies
Relevance 77.9%

hello to everybody

I need batch code to check if date is modified in three files and that date should be compared with current date (%date%).If so,do some job,otherwise quit (exit /b)

I found a bunch of solutions but what troubles me is date format.
On my machine it is dd.mm.yyyy

Thanks in advance.
 

Answer:Solved: batch to compare file modified date with current date

10 more replies
Relevance 77.9%

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

I need to return a number associated with a date based on today's date. For example: A1:A24 are numbers 1 to 24 and B1:B24 contain the 15th and 30th for each month of the year; 15-Jan, 30-Jan, 15-Feb, 28-Feb, ... 30-Dec.Cell C1 needs to return the number from A1:A24 based upon today's date compared to the date in B1:B24.For example today is 08/21/15, what number should be returned in Cell C1. It should be 15 as 08/21 is less than 30-Aug.message edited by jmichels

Answer:Return a number based on today's date compared another date.

Try this formula, see how it work for you:=INDEX(A1:B24,MATCH(TODAY(),B1:B24,1),1)This will work for most dates, but errors out if the Date is 01/14/15 or less.MIKEhttp://www.skeptic.com/message edited by mmcconaghy

4 more replies
Relevance 77.49%

Hi all,I need dos command to compare the file creation date and the modified date.My scenario is,If user inputs the folder path to the batch file, i have to provide the file list (which are under sub folders of the given folder) ,which do ot have creation date and modified date as same.can anyone help in thisThanksVanisree

Answer:Dos command to compare file creation date and modified date

You need a CMD.EXE Command Prompt solution, XP does not have MS-DOShttp://ss64.com/nt/ARM Devices are the future, great British Design !

2 more replies
Relevance 77.49%

I have a field that reads 2009-12-30-15.42.22.81298 as text. i want to make in be a date of 12/30/2009 15:42:23 and ignore the milliseconds. Is this possible?

Thanks
Ted
 

Answer:Converting complex date text fields into date or numbers

Ted, what software are you talking about?
Are there always 8 values in the date part?
 

3 more replies
Relevance 77.49%

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?

Thanks
Steven

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

Hi,

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.


OS

9 more replies
Relevance 77.49%

Hi all,I wish to create a macro that when i click a button i can input what month i wish to print out data for. I have 7 columns (A-G).Date Day Activity Income 02/01/2012 Monday Work (8) 48.00 02/01/2012 HMOT 5.00 02/01/2012 Peter Taylor 134024855 HMOT 5.00 02/01/2012 Susan Taylor 134023422 HMOT 5.00 02/01/2012 Steve Davy 13402737404/01/2012 Wednesday Work (8) 48.00 04/01/2012 HMOT 5.00 04/01/2012 Tom Thompson 134027410 HMOT 5.00 04/01/2012 John Ackroyd 134025131 HMOT 5.00 04/01/2012 Aftab Ilahi 134022546Above is an example of the sheet.In column A we have the date, B we have the day, C we have the activity, D we have the income, E is a cell with the previous month date in to track data for the month, F is a name and G is a number.I wish to be able to print all of january for example, rows A-G by clicking a button and entering something like 'january' or '01/12'. This will then select all of the rows with data in based on the date range in column A and print the selection.Please feel free if that doesn't make sense to ask questions.Thanks in advance.

Answer:acro to input date and print based on date range

Below is the code I have for a macro which I can't seem to get to work right.Thanks.
Public Sub PrintMonth()
On Error GoTo Proc_Error

Dim wksCurr As Worksheet
Dim rngTarget As Range

Dim strInput As String
Dim datInput As Date
Dim datStart As Date
Dim datEnd As Date

strInput = InputBox("input start date for month", "Enter date")
If strInput > "" Then
datInput = CDate(strInput)
If datInput > 0 Then
Set wksCurr = ActiveSheet
Set rngTarget = wksCurr.Columns(4)
datStart = WorksheetFunction.EoMonth(datInput, -1) + 1
datEnd = WorksheetFunction.EoMonth(datInput, 0) + 1
With wksCurr
If .AutoFilterMode Then
.AutoFilterMode = False
End If
.UsedRange.AutoFilter Field:=rngTarget.Column, Criteria1:=">=" & datStart, _
Operator:=xlAnd, Criteria2:="<" & datEnd
.PrintOut
.AutoFilterMode = False
End With

Set rngTarget = Nothing
Set rngDate = Nothing
Set wksCurr = Nothing
End If
End If

Proc_Exit:

Exit Sub

Proc_Error:

Select Case Err
Case Else
MsgBox "Error " & CStr(Err) & ": " & Err.Description
Resume Proc_Exit
End Select

Exit Sub

End Sub

3 more replies
Relevance 77.08%

Hi all
One thing bothers me with this build

From the Microsoft announcements I thought the expiry date of this build would be around May / June 2010.

The Winver info shown in Airbots screenshot shows Mar 03 2010.

I haven't installed yet so I cant check the date with SIW which for my current build (7077 x-64) shows 01 June 2010.

Airbot -- could you show the SIW info -- see if it gives expiration date of 2010. Thanks.

Here's mine for build 7077 x-64

Cheers
jimbo

Answer:X-86 Expiration date ? 03 Mar 2010

Ok , here it is Jimbo. But please post your threads in the appropriate forums, as this is not considered news.


moved to general discussion

9 more replies
Relevance 77.08%
Answer:New PC had 2010 as date - problem?

Just got a new PC. Set it up last night and checked the date/time was right before proceeding. Realised this morning that although time and date were right, the PC had shipped with the year set to 2010!This means I now have 229 files with 2010 as their creation/modification date. Some I can delete as they relate to software I've installed, but some are registry? (is it still the registry on XP) files so I don't want to touch them. It's probably not a problem, but of course if I do searchs for recently created/modified files, it'll always come up with'em!! OK, so I can bracket the dates I search on, but this is far too time consuming!Also, Windows95 let you search for "files modified in the last X days" so you could narrow it down to very recent files. Why does XP only let you choose "1 week"? Can this be changedCheersDave

6 more replies
Relevance 76.67%

I've just moved "My Documents" contents from one laptop to another
I now find that some of the Word Documents are showing the current date in letters to customers that were created & dated months ago
As these letters are records documents sent out is there a way of preventing them opening with the current date

I've already checked, Wotd - Insert - Date & Time & the Automatic Updates box is unchecked

Thanks for any help

Answer:In Word the Original Date in a letter changes to current date

Is this the file modified date or the file created date? Moving the file will give it a new "modified" date.

1 more replies
Relevance 76.67%

Hi All,
I am using LUMIA 1320 that has Lumia Cyan.
Sometimes the time and date is getting reset to a specific date, i.e. 22nd May 2014
Due to this all reminder, alarms and new messages are not coming in sync.
Is this a virus? Does it have come from an app. If that is the case then it questions Microsoft App policies...
Anyone who has encountered this issue and has done something to eradicate it let me know.

Answer:Why is my phones time and date getting reset to a specific date?

First, windows phone can never get a virus. Its the safest platform after iOS . And no, a particular app can't affect the system's time and date. I think your should try to manually set the time and date in the settings. And see if it works.

3 more replies
Relevance 76.67%
Answer:ican not set date and time an error is occurewhile date and

Enter the BIOS & change the date/time. If it resets after the system has been shutdown for a while & then restarted, the CMOS battery is probably bad.

2 more replies
Relevance 76.67%

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

I want to calculate how long a member of staff has worked for the company and therefore need to subtract their starting date from the current date.

Answer:How to subtract a date from a date ie years/months elapsed

If you use google to search:Time elapsed calculatorThere are a few online results to help. I hope they help. For the fun of it I calculated how long I have been in existence : 2,177.43 total weeks or: 15,242.00 total days or: 365,808.00 total hours or: 21,948,480.00 total minutes or: 1,316,908,800.00 total secondsThat was from the first result google gave me. Thank god no one will be able to figure out when I was born. message edited by btk1w1

9 more replies
Relevance 76.67%

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

ok i have a folder on my HD that contains over 60GB of data. within this folder there is many folders and files. is there a way of simply selecting this main 60GB folder and useing a prog to make all the file and folders have the same date/time that i wish?

i basicly want all the files and folders in this 60GB folder to be ...say todays date / time.

can this be done?
 

Answer:file date on a 60GB folder - setting them all to the same date? can it be done?

http://www.febooti.com/products/filetweak/

40 day fully working trial version.

Looks like it will do what you want.
 

1 more replies
Relevance 76.67%

Hello, I am having trouble finding the previous 2 days totals in a query. I have a totals query with the following fields:
JobID - Criteria: Between 500 And 599
WorkType
JulianDate
Batch
TotalProcessed - calculated field, grouped on Sum. sums field entry
ProdDate - Short Date - Grouped on Where - Criteria Date()-1 Or Date()-2

Today's Julian Date is 199 so query should give me Julian Dates 197 & 198, but instead returns Julian Dates 188 - 196.

Thank you for your help!
 

Answer:Solved: AC2007 Find Date()-1 And Date()-2 in Query

The criteria that you should use for a date period is
Between Date()-1 and Date()-2
 

2 more replies
Relevance 76.67%

The column heading in Win 10 File Explorer is 'Date'. But which one?

I've always been used in XP to the default being 'Date modified', but it seems that here it's Date created? Several re-saves have left 'Date' unchanged.

--
Terry, East Grinstead, UK

Answer:File Explorer Date column - whiich date is it?

Hi:
What is the column in Windows 7 explorer? It matches no date column from Windows XP explorer - Super User

2 more replies
Relevance 76.67%

Dell Dimensions XP PC bought 9 years ago.On opening date 7 time reverts to date of purchase.Can change and all ok.Can anyone Help Please? Thank you

Answer:Date & Time reverts to Date of PC purchase 9 Years Ago

Wait for the more knowledgeable to report but a new CMOS Battery would seem to be in order.
Easy to replace and only £1, or so, to buy, in almost any Supermarket.
About the size of a 10p piece on the motherboard, with a number like CM032. Don't take it out until you are ready to replace it.
Get the replacement > Take the old one out > Instal the new one and, with luck, that should be it.

6 more replies
Relevance 76.67%

I am using the "microsoft access date/ time picker" control to pick dates. These dates like termination date of a contract will end up in the database. The problem I have is that when I do this,

rst!dateIntoForce = Me!ActiveXCtlDOForce

I end up with this in my database:

1/6/2003 5:48:43 PM

How can I extract only the date part from "1/6/2003 5:48:43 PM" so that only

1/6/2003

goes into the database
Thanks
 

Answer:Date Part only from MS Access Date picker control

Format the date before it gets entered into the db. Format([Date], "m/dd/yyyy")
 

1 more replies
Relevance 76.67%

Dell Dimensions XP PC bought 9 years ago.On opening date 7 time reverts to date of purchase.Can change and all ok.Can anyone Help Please? Thank you

Answer:Date & Time reverts to Date of PC purchase 9 Years Ago

http://www.pcadvisor.co.uk/forums/1/tech-helproom/4204823/date-amp-time-reverts-to-date-of-pc-purchase-9-years-ago/
see duplicate thread

1 more replies
Relevance 76.67%

Hi there

I know how to do add a criteria to a Query. For example in the QBE pane in design view in the criteria row I enter this statement: Between [Start Date] And [End Date]. When I open up the form that is bound to the query, a message box pops up and I enter the required dates and I get the required data that is between the dates that I specify. However, I'm now finding out that this method is now becoming a nuisance.

Is there a way that I can have 2 unbound controls - one for the start date and the other for the end date in a criteria form. This way I input the dates I want for a particular customer and the form with the required data shows up. For example, I have already developed a criteria form for customers. I have an unbound combo box control that has customer names and when I click on a particular customer name, all the data for that customer is displayed in a form. In the row source of the unbound combo box control there is a SELECT .... FROM ... statement. I also have a button next to the unbound combo box control that opens up the form for that particular customer. Now I want to add two more Unbound controls in the criteria form, one for Start Date and another for End Date.

This way I can select a customer from the customer combo Box, select the start start date from the start date combo box and the end date from the second combo box control and get the desired data for that particular customer between the specified dates. I have attempted to do this bu... Read more

Answer:Access - Start Date and End Date in a Criteria form

Mario: What you want is called a query by form (QBF). I don't know how to do them myself, offhand, but here's the MS Technet article:
http://support.microsoft.com/?kbid=235359
 

2 more replies
Relevance 76.67%

I have a Date/Time field that I need converted to just a Time field.

It comes back with 2/11/12 0:00:00

I need just the 2/11/12

I thought about changing it to a text field but I think there will be an issue with the month because it does not bring back a 0 in from the months with only 1 digit.

This table that I am creating is being sent to a txt file and that is where I see the issue. It looks good in Access, but not the txt file.

Any suggestions?
 

Answer:Solved: Access - Convert Date Time to Date

10 more replies
Relevance 76.67%

The AVG on my Dell thinks the Virus database is out of date even though it has the most current update?

How can I change the date back and what might have caused this to happen in the first place. I've heard of some AVG update problem but didn't find much relevant information on it.

Any suggestion or links would be great.

Thanks,
Andre
 

Answer:AVG Free wrong date set; Update thinks it's out-of-date

Check the date on your computer.. And, maybe uninstall AVG and reinstall it..

http://www.majorgeeks.com/AVG_Free_Edition_d886.html
 

2 more replies
Relevance 76.26%

I have constructed a database for membership of a small club. I would like to know how to calculate the type of membership for members based on the number of years they have been in the club. ie joined in 1996 and therefore have been members for 16 years this makes them a full member and will cost 45. How can I do this ?

Help please

mepsele
 

Answer:Date calculation in Access 2010

Welcome to TSG mepsele, hope you find some answers and take the time to help others when you get a chance. Thats how the communinty works.

This expression will give you the date difference between Now and a date field (I used ED_Date) in years.
Expr1: DateDiff("yyyy",[ED_Date],Now())
 

1 more replies
Relevance 76.26%

Hi all
The difference in the expiry date bewteen WINVER and SIW has been bugging me -- I know it's a moot point since RTM will be out LONG before then but some things just stay in the brain.

Anyway the REAL expiry date is based on the Licensing procedure

so if you type in elevated command mode

slmgr /dlv

you'll find the expiry date is (in my case) 02 june 2010 -- yours might be 01 June 2010 -- depending on regional code and when you installed it.

After entering the command wait a few seconds for a new window to appear.

So SIW has it.

enc image

cheers
jimbo

Answer:Expiry date of RC is actually JUNE not MAR 2010

jimbo are u sure it aint the 6th febuary 2010.
i just checked mine and its the same as yours 02/06/2010 i also checked winver and that says 02/03/2010 3 months differance sounds a lot but 3 days seems more like it does anybody know how ms writes these things is it month first or day first like normal people

8 more replies
Relevance 76.26%

Hello,

1st Question:

I'm currently building a Database for my job. I have a field titled "Date Received." What I want to have access do is automatically populate a "Due Date" for 2 business days after the "Date Received" field.


2nd Question:

In my database there is a "Status" field where the agents will be able to select a status from a drop down menu. Is there a way to keep record (auto Date/Time stamp) every time the status is changed? How do I do this?

I have this in a Form. I'm fairly new to ACCESS but am a quick learner. Please help me with this!!!!

Thank you for any help! Just joined this site today so I hope I can find the help I so need!
 

Answer:MS-ACCESS 2010 - Date Stamps

I need help! Some one please help me with this!
 

16 more replies
Relevance 76.26%

I need to put a date on a label that is generated from a report in an Access 2010 database. When the user runs the label report they need to be prompted to enter a date so it will print on the label.
 

Answer:Access 2010 Calculated Date

6 more replies
Relevance 76.26%

I am having trouble getting my date control to work properly. I am using Word 2010. I have added a reference to Microsoft Windows Common Controls-2 6.0 (SP6), I have added the date picker control to my tool box. I have added the date controls to my form and I named my date controls dtDate1 & dtDate2. My code is this:
Code:
Dim datDate1 as Date, datDate2 as Date
datDate1 = dtDate1
datDate2 = dtDate2
Msgbox = "Date 1 is " & datDate1
Msgbox = "Date 2 is " & datDate2

When I run this and enter the appropriate dates into the form, I get "Date 1 is 12:00:00 AM" and "Date 2 is 12:00:00 AM". I do not get dates, I get times. Both controls are set to the format dtpShortDate.

I also tried
Code:
Dim datDate1 as Date, datDate2 as Date
datDate1 = CDate(dtDate1)
datDate2 = CDate(dtDate2)
Msgbox = "Date 1 is " & datDate1
Msgbox = "Date 2 is " & datDate2

with the same result.
I need to grab the dates and manipulate them elsewhere in the code. Please, any help would be greatly appreciated.

Thank you.
 

More replies
Relevance 76.26%

I have the responsibility for keeping a record of the names of the volunteers who have volunteered to man the Visitor centre on a particular date.

The table I have created is

ID
Date
Special info
Morning
Afternoon

Basically this is just a diary.

A selection of this table will be printed off at regular intervals using a Query and then a Report The volunteers will add their names to the printed sheet for their chosen dates, morning or afternoon and the database updated on a weekly basis.

My question is this - can I automatically create the date that appears in the second field [Date] from the [ID] field or must I enter each date for each day manually.

Any other advice will be gratefully received
 

Answer:Creating a date in Outlook 2010

I have posted this and a very similar post under a similar title.

I apologise for this error - I can only put it down to old age and, unusually for me, far too much work on my plate.

This is not my usual practice and I will ensure that it doesn't happen again.
 

3 more replies
Relevance 76.26%

Hi guys,

This is my first post, but I've checked around and this community looks like it knows its stuff so I hope you can help me .

I'm currently developing a equipment management database. I have a table storing the different pieces of equipment and another table that records when pieces of equipment are down for maintenance.

Now I need to have reports come out that specify each equipments availability for the week, month, and year to date. I believe doing this with queries may bog down the database in the coming months or maybe a year or so down the road. So what I would like is to create another table that records daily availability.

The basic things that I am unsure how to do yet but I believe I can figure it out on my own is having this table update automatically the previous day's records with each machines availability in a % form, (ex: truck down for 12 hours means 50% availability).

The part where I am unsure how to proceed is getting this availability recorded and keeping it current. I can't have the Availability table restricted to looking at one record in the Down table because an item may go down twice or more in one day generating two or more records in the Down table. Also it is often that the maintenance may not be recorded properly and need altering at a later date or that it wasn't recorded at all and a new Down record must be created. This would need to effect the corresponding date in the Availability table for that piece of... Read more

Answer:Access 2010 Date Tracking

16 more replies
Relevance 75.44%

i lost my office 07 disc, so i figured i'd test out office '10. the only thing is that i can't seem to find out when the beta expires. would anybody happen to know? i don't want to be stuck without word once it expires.

Answer:office 2010 beta expiration date

October 31st, 2010.

8 more replies
Relevance 75.44%

Hi,
I'm using Microsoft Word 2010
Instead of typing in "today's date" every time.....
How do I modify the date macro I made for Excel so it will work in Word.
And where do i put it ?

Then I can have an Icon on the Ribbon !!
HTML:
ActiveCell.FormulaR1C1 = "=TODAY()"
Selection.NumberFormat = "mmmm/dd/yyyy"
Selection.Value = Selection.Value
mike
 

Answer:Solved: Macro for date in Word 2010

6 more replies
Relevance 75.44%

I have the responsibility for keeping a record of the names of the volunteers who have volunteered to man the Visitor centre on a particular date.

The table I have created is

ID
Date
Special info
Morning
Afternoon

Basically this is just a diary.

A selection of this table will be printed off at regular intervals using a Query and then a Report The volunteers will add their names to the printed sheet for their chosen dates, morning or afternoon and the database updated on a weekly basis.

My question is this - can I automatically create the date that appears in the second field [Date] from the [ID] field or must I enter each date for each day manually.

Any other advice will be gratefully received
 

Answer:Automatic date creation Outlook 2010

welcome to PCR

please, stick with one thread on the same topic

https://www.pcreview.co.uk/forums/thread-4023580.php


I can't help, don't use the software.




 

3 more replies
Relevance 75.44%

I'm still a rookie with MS Access, and I know some of you Access guru's will know the answer to this.

I need a validation rule that will give a popup window warning if the date entered is MORE than 180 days from todays date. Can anyone help?

Thanks
 

Answer:MS Access 2010 date validation rule

Set the after update event handler to compare the date entered meets the criteria.

If Me.Textfield >= Date() +180 Then
Do something
Else
continue
End If
 

2 more replies
Relevance 75.44%

Is it possble to have a an appointment re-occur every month on a specfic date, using the recurrence option.
i.e 1st of every month (regardless of the day), without scheduling the meeting for each month?

Regards

Answer:Outlook 2010 - Recurring appointment by date

Hi Apache,

Yes, it is possible.

Steps:

1. Open Outlook and click on the Calender to get into Calender View.
2. Right-click on the 1st of a your chosen month, and select the New Reccuring Appointment option
3. You can now edit the finer details of the appointment.

Refer to the image as shown below. Post back here if you need more help with this.

Regards,
Golden

3 more replies
Relevance 75.44%

Hi,

I am working with a database that is added to every day and I need to be able to pull out those records that apply to an overnight shift. The start time is given as dd/mm/yyyy hh:mm:ss and I want to be able to select all the records for shifts that started between 19:00 on the day before and 06:00 of the morning I run the query.

As this needs to be done everyday I was hoping that a query could use the criteria of Date()-1 and Date() along with the times to select those records, so I have tried this (and a few variations of this) but nothing has worked so far

SELECT Table1
WHERE StartTime BETWEEN Date()-1 #19:00:00# And Date() #06:00:00#

Can anyone help me with this?

Many thanks!
 

More replies
Relevance 75.44%

I'm having trouble creating a macro to insert the current date (static).

Here's what I'm doing:
View > Macros > Record
Name: "Date"
Store macro in: keyboard Shortcuts
Click on keyboard picture
Insert: CRTL+D & click Assign
Record: I have tried all the following:

(/@"mm,dd,yy")
"mm,dd,yy"
/@"mm,dd,yy"
(/@ "mm,dd,yy")
(DATE/@?mm/dd/yy?)


Then Stop Recording

When I hit CRTL+D I get exactly the code I put in instead of the date "02/12/13"

What code should I be inserting to get today's date?

Thanks, Mike

Answer:Create a Date macro Word 2010

Welcome to the Seven Forums.

start recording
select insert (upper left)
select date & time (upper right)
select the format that you want
click OK to exit the dialog box
stop recording

4 more replies
Relevance 75.44%

Hi all!
Before I ask my question I just want to let everyone know that this site has been a great help.

So, I have a TextBox that needs to accept a date and time. Simple enough. However, the data that I need to collect has to always have a date and time but when I use General Date it will accept either Date or Time or both as its designed to do so.

I have tried setting

Format as " m/d/yyyy h:nn:ss ampm "
Input Mask as " 90/90/0000\ 99:00:00\ >LL;0;_ "

and tinkered with me.textbox.format() as an if statment

But this leads to the other issue that most of this data will be pasted into the form in either of the below formats.

7/19/2017 12:08:14 PM
Wednesday, July 19, 2017 12:08:14 PM

I'm stumped and haven't been able to figure this out through research or my own luck.

Any help is appreciated and thank you all.
 

Answer:General Date Forced To Have Date And Time

So.... I think I figured it out. Been testing it and it seems to result in the way i need it to. So I have the Form/Table set to Date/Time Field formatted as a General Date. This will at least validate that the information inputted in the text-box is a date/time of some sort. Then I added the below code to make it follow a validation rule of sort. So far it seems regardless of the way information is pasted in the end result is always MM/DD/YYYY HH:MM:SS AMPM
If Me.YourTextBox Like "**/**/**** **:**:** **" Then
Cancel = False
Else
MsgBox ("Please enter a date and time in this format MM/DD/YYYY HH:MM:SS AM/PM")
Cancel = True
End If
I'm still open to suggestions if there is a more efficient way of doing this. If not I hope this information will be found helpful to others.
Thanks All,
 

5 more replies
Relevance 75.44%

When viewing the software downloads page, all of the update dates are newer than the release dates.  And they are all very close to current date (Jun 20).  Running the HP tool doesn't show any update is needed.  So I'm puzzled. Are all these drivers/patches really out of date or is the earlier release date still the correct one.  Surprised that every available update shows close to current date.    

Answer:Update Date does not Match Release Date

Hi: The date you see next to the actual driver exe file is the correct driver date. The 'update' date you see is because HP redesigned the website and had to upload many of the drivers again.

1 more replies
Relevance 75.44%

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

All --

Please help with this question about file data created VS date modifed in Windows 7.

Suppose a file is created at time1.

How come Windows7 reports "date created" as "time1" and "date modified" as "time2" where "time2" is a time earlier than time1?

See the attached file, "WindowsDateIssue201203061503.png", for an example.

Thanks.

-- Mark Kamoski
 

Answer:date-created VS date-modified on Windows 7

Good question, but it does not effect the performance of the computer.
An explanation could be the DLL file could be updated via a recent Windows update and it was last modified date was inherited from the previous file that has been overwritten.
 

2 more replies
Relevance 75.44%

Well AVG 7.5 is reporting that it's internal virus database is out-of date so when I update it it says that it is fully updated, but still reports that it isn't. I have no idea what is going on here so if anyoen can help me it would be great!

Thanks, David.

Answer:Avg 7.5 Reports It Is Out-of-date And When I Update It Says Its Fully Up-to-date!

I just thought of this, has AVG not released any updates since January 31st 2008? Is anyone else having this problem, I have looked on the internet an the latest updates for AVG 7.5 are January31st.

I think something is wrong here.

9 more replies