Computer Support Forum

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

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

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!

Relevance 100%
Preferred Solution: Julian Date--How to convert to calendar date in Excel

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: 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 117.74%

Hi,Could someone please tell me how to convert dates in Excel to Persian calendar dates? Is there a simple formula?message edited by Esfahan

Answer:convert julian calendar date to persian calendar date in exc

It does not look like it will be an easy job to do the conversion.Here is a thread that you may find helpful:http://www.computing.net/answers/of...MIKEhttp://www.skeptic.com/message edited by mmcconaghy

2 more replies
Relevance 84.97%

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

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

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

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

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

10 more replies
Relevance 84.68%

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

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

I have a Julian day e.g 57572255 in excel and I need to get this into date dd.mm.yyyy and hh.mm.ss. I have managed to sort the date, hour and minutes as 16/06/2009 17:35 but can't work out the seconds.
 

Answer:Julian Day into date and hh:mm:ss

8 more replies
Relevance 104.55%

I often have a need to convert julian date info to Gregorian date (not via software, but to know what day the number represents). I found this website: http://www.buygold.net/v04n09/v04n09.html that provides a nice little visual interface. I've downloaded the VBA code, but I don't know how to put it to use.

Can someone please advise? Thanks!

If you can recommend other utilities, I'd also appreciate that! I had been using this site: http://wwwmacho.mcmaster.ca/JAVA/JD.html, but it's not very purty
 

Answer:Julian to Gregorian Date

7 more replies
Relevance 100.45%

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

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

I have not found a solutions which worked, datevalue returned #value etc. The basic problem is if your system date is not according to the date format in your text date column. So if you have set it to ISO, starting with the year, datevalue will not work etc.
This procedure worked fianally:

If the date format is like '12/31/2011 (US Format)
1. Change date format in CtrlPanel Regional & Language Option to the corresponding format, in this case mm/dd/yyyy
2. Select column with dates
3. Format Cells General.
Dates will change to Datevalue 40908 (Nbr of days since 01/01/1900)
4. Format Custom i.e. ISO Format yyyy/mm/dd (which really should be used everywhere)
5. Voila 2011/12/31
6. Change date Format in CtrPanel back to your Format
 

More replies
Relevance 100.04%

Hi,
Can anyone helpme oconvert the date in excel to milliseconds.

Thanks
Madhu
 

Answer:Convert date to milliseconds in Excel

How exactly do you mean? Milliseconds from the current date?

Also, what format is the date in?
 

7 more replies
Relevance 100.04%

How can I convert a date in format DDMMYY to DD/MM/YYYY in Excel 2002.Thanks Steve.

Answer:convert date ddmmyy to dd/mm/yy in excel

Your looking for a Custom Format:On the Format menu, click Cells.On the Number tab, click Custom from the Category list.In the Type box overwrite what ever is in there, probably the word Generalwith:DD/MM/YYYYclick OKMIKEhttp://www.skeptic.com/

2 more replies
Relevance 100.04%

Ok what Im trying to do sounds very simple... I just cant get to the right format.Lets say I have a date like 8/2/12 or 12/31/12I need to make an if condition where if the date is after lets say 10/31/12 the user would get a pop up error message saying to use a current version.Im just trying to force users to keep up with the current forms that I realize to them, caus ethey just keep using the old versions caus ethey are lazy as hell.I know how to make the if condition and the error pop up message.I just need Excel to convert the date into numbers like 8/2/12 = 41123 in the background without showing it.So if the date is 10/31/12 = 41213 I want excel to stop the process and give an error message to the user.Something like
CurrentDate = 08/02/12
If (CurrentDate) > 41213 then
MsgBox "Dude use the current form"
Else
About 4 pages of code
End If
Note: when I take the date from another screen it comes as "08/02/12"Always 8 charactersThanks in advance!!!

Answer:EXCEL Convert date to number

This code should get you what you asked for, but I think you are making it more complicated than it has to be.
Sub CompareDateSerials()
DealDate = "8/2/12"
dVal = DateValue(DealDate)
dSer = Format(dVal, "####") 'returns date as serial number (41123)
If dSer > 41213 Then
MsgBox "Dude use the current form"
End If
End SubHowever, you don't need to convert it to the serial number. You can just compare the DateValues.
Sub CompareDateValues()
DealDate = "8/2/13"
If DateValue(DealDate) > DateValue("10/31/12") Then
MsgBox "Dude use the current form"
End If
End Sub
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

3 more replies
Relevance 98.81%

Why are some of my dates changing (the month and day are swapping places) when I have a pdf file and do a file - save as - spreadsheet - Microsoft Excel Workbook???Some of the dates convert correctly, but some of them are not. Such as...9-11-2014 will show up as 11-9-2014...

Answer:Date format incorrect when I convert from pdf to excel

Since I don't have the ability to save pdf's as Excel spreadsheets I can't test the proces. The best I can do is speculate.I also don't know by your examples what format your examples are in. You say the month and day are swapping places, but I don't know if the original (9-11-2014) is supposed to be mm-dd-yyyy or dd-mm-yyyy since 9 and 11 could be either a month or a day. It would be interesting to see what would happen if the dates in the pdf were 11-22-2014 or 22-11-2014, depending on which format they are using in the pdf.In any case...For the dates that are changing to a different format, it is possible that your system is converting them to correspond with the format set within your regional settings. Excel may be assuming that e.g. 9-11-2014 is mm-dd-yyyy but your regional setting is dd-mm-yyyy so Excel converts it for you. It's just trying to be nice. ;-)For the dates that are not changing, it is possible that Excel is not actually seeing them as dates but rather as text. It is a well known annoyance within Excel that dates imported from "outside sources" (web pages, databases, etc.) are not always seen as dates by Excel. Changing the cell format to one of the date formats doesn't help, since Excel doesn't consider the contents to be a date. If Excel is not seeing some of the "dates" as dates, then it won't convert them to match your regional settings.Sorry, but that's the best I can offer at this point.Click Here Before Posting Data or VBA Code ---> How To Post Data ... Read more

3 more replies
Relevance 97.99%

How do I convert a date that appears in 3 columns to a single column date i.e. column A has MONTH( Jan shows as a 1, Feb as a 2), column B has DAY(I.E. 3 OR 4 OR 10) and column C has Year (2 DIGITS 2010 shows as 10 or 2011 as 11)..want to convert to signle column 01/03/10...

Answer:in excel convert 3 column date to single colu

Concatenation (&) of values from multiple cells creates a "text string".DATEVALUE converts a text string into a date as long as Excel can recognize the structure of the text string as a date.Putting those 2 facts together, try this:=DATEVALUE(A1 & "/" & B1 & "/" & C1)

4 more replies
Relevance 96.76%

I imported data from another program into Excel and it is giving me the date and time in this format:10012015 01:40I need it to look like this:10/01/2015 01:40The data is in Cell R72. When I use the formula below, it comes up as 8/15/03 1:40 instead of 10/01/2015 01:40.=DATE(MID(R72,1,4),MID(R72,5,2),MID(R72,7,2))+TIME(MID(R72,10,2),RIGHT(R72,2),0)Any help would be appreciated!message edited by rajasperson

Answer:Convert text string to Date and Time format in Excel

Try this:=DATE(MID(R72,5,4),LEFT(R72,2),MID(R72,3,2))+TIMEVALUE(RIGHT(R72,5))The syntax for the DATE() Function is: =DATE(Year , Month , Day)The Year starts at the 5th Character and is 4 Characters longFor the Month we get the First Two characters from the LEFT() side of the text string.For the Day we start at the 3rd Character and get 2 characters.MIKEhttp://www.skeptic.com/message edited by mmcconaghy

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

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

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

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

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

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

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

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

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

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

Answer:Excel 2010 UK Date to US Date

11 more replies
Relevance 87.74%

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 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.59%
Question: convert date

I have table access database 2003 with date column have data in this format:
mm/dd/yyyy eg 04/28/2013.

My question is: Is there anyway that I can convert that format mm/dd/yyyy into
dd/mm/yyyy (28/04/2013) by creating query?

How to do this?,

Thanks & Regards
 

Answer:convert date

Have a look at THIS and see if it is of any help.

Welcome to the forum

 

3 more replies
Relevance 81.18%

We Belong to a wine circle we are all retired some have a little computer knowledge but all have a computer.
I have been asked what would be the best way to create a Diary date calendar of where we are meeting, date and who will be attending.

All have microsoft Office but not all have Outlook
Any help I would be most grateful

Thank You
 

Answer:Booking date calendar

In your case I think you could use a Google account, it has a calendar which can be shared with your group of friends
Everybody can make a Gmail account
 

1 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 80.36%

Anyone know how to convert a date format, e.g. 21/05/10 to 'Fri' please?It would save me a lotta time n effort if I knew.Thanks in advance.C.

Answer:Convert Date to Day of Week?

Use ExcelTry this=CHOOSE(WEEKDAY(A1),"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday")Day of the week calculater at bootom of page click here

2 more replies
Relevance 80.36%

I have a file which contains dates both in the format 2005/01/01 and 01/01/2005. I need to get the 01/01/2005 cells to reflect the 2005/01/01 format so that the database can easily be sorted by date. Any ideas?Thank,Frik

Answer:Convert Date Sequence

I just tried what I suggested in Excel 2010 and everything worked just as I described, including the Sort dialog box.Since I was able to convert the text strings in the file you sent me in both 2003 and 2010, there's only 2 other things I can suggest:1 - Change the date format in your Regional and Language Options control panel to MM/dd/yyyy so it matches mine.2 - Try my steps on someone else's machine.If neither of those work, I have no further suggestions. I'm using your spreadsheet and I can convert the text strings to dates and sort them, so I don't know what else to offer.Good luck!Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

28 more replies
Relevance 80.36%

I want to convert a text like 20120825 to a date format like this 2012/08/25

Answer:Convert text to date

=LEFT(A1,4)&"/"&MID(A1,5,2)&"/"&RIGHT(A1,2)Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

3 more replies
Relevance 80.36%

Hi there

I have seen on events pages that it is possible to add a facility that when someone is interested in an event, they click on a link and the information relating to that event is automatically inserted into their Outlook calendar (time, date, venue etc).

I have absolutely no idea where to start - can anyone help please?!

Thank you.
 

More replies
Relevance 80.36%

Hello,

I opened Outlook Calendar the other day, and the dates which are at the top of each calendar square in the month view are a scrambled mess! They look something like this:
2007200720072007 | 2007 Sep 90012 12Sep92007 | 2007200712125SepSep 12Sep92007|

Does anyone have any idea what is going on here?

Thank you for your help in advance!

Regards,

Jerry
 

Answer:Date Problem in Outlook Calendar

Could we get a screenshot please ?? Preliminarily I would say this could be due to a corrupt pst file or profile. Try creating a new profile and importing the data to it. Else you might simply want to create a new pst file and include it Outlook.
 

3 more replies
Relevance 80.36%

OK, I'm doing up an HTML evite and I need to find code that will allow the recipient to click on a button which will save a specific date to his/her outlook calendar. Help meeeee? :]
 

Answer:Saving a date to Outlook calendar

Closing thread.

Please do not create duplicate threads.
Continue replies here: http://forums.techguy.org/business-applications/555846-saving-date-outlook-calendar.html

Thank you
 

1 more replies
Relevance 80.36%

Using Windows 8 Pro (RTM)
Seems like the calendar app does not obey the language settings.
W8 display language is English (US I think) and that is the way I want it even if I want day names and time format as choosen in language settings.

Hints ?

Answer:Calendar app time/date format

Hi eager2008. Welcome to the forum.

Right click the app -> Uninstall

Reboot.

Open Store (tile) -> Mouse curser to upper right (Charms menu for store app slides out) -> Find (magnifying glass) -> type calendar. It will bring up the app to install again.

Please let us know if that works or not. Good luck.

14 more replies
Relevance 80.36%

I am using Word 2007 and I have created a template with a custom userform. There is an area in my document where a future day and date is needed and I would like to put a calendar or date picker on the userform for the user to select the date, but there is no control in the toolbox for a calendar. Is there another way to add a calendar or date picker to my userform and if so, how do I code it so that the date format shows as Monday, June 15, 2009 in the form?
 

Answer:Solved: Calendar or date picker

OK, I found the calendar control and put it in my userform. Now I need to know how to code it. When you select a date, it shows up in the document in this format: 6/14/09. I want it to show up as Monday, June 14, 2009. Thanks for any help.
 

1 more replies
Relevance 80.36%

Hi folks,
I need a little help how to have reminder date from Excel xls into Outlook calendar.
It might be simple but our office IT guys couldn&#8217;t figure out so I need some help... I created a sample xls file with proper columns &#8211; attached. I am not a programmer so I am trying to figure out how to have automatic reminders 3 days before the &#8220;Start Date&#8221; which will be different for each item and there will be thousands of items on this list.

I appreciate your help.
Thanks

PS I forgot to attach my xls and do not see a way to edit and attached so I may have to attach it in a reply...
or you can download from here http://www.allreversephonelookup.com/excel/info.xls

 

More replies
Relevance 80.36%

Hi guys I have just installed windows 10 home not pro and I have managed to sort out the date format in the taskbar (bottom right) into UK format but I have started to use the calendar but that format is still in USA format and I want to change it.
I added google calendar but not sure which setting I need to be changing I have looked in my google account and that says UK date format so i'm thinking its an outlook setting maybe.

hoping the photo shows below the app/software and have also put the app icon under the photo

as you can see in the red box it says 1/9 when in the UK it should read 9/1

can anyone help please?

Answer:windows 10 calendar date format

Hi have you tried this
Down the bottom you will see More Calendars
Click on it and scroll down to UK put a tick in it
Also make sure the USA one is unticked
That should bring up the date and month in the right order you want it
Hope that helps
Let us know how it goes

12 more replies
Relevance 80.36%

I have a few tasks that have due dates. Is it possible to show those deadlines in the calendar as well?Thanks

Answer:Is it possible to show the Task due date in the calendar?

What Calender ? ?

2 more replies
Relevance 80.36%

OK, I'm doing up an HTML evite and I need to find code that will allow the recipient to click on a button which will save a specific date to his/her outlook calendar. Lil' help?
 

More replies
Relevance 80.36%

My desktop calendar in Windows XP home edition iss stuck on July 22 even though the time on the taskbar shows the correct month and day. How do I bring it up to the correct date?

Thanks for any help provided.
 

Answer:Desktop Calendar Not Changing Date

Right-click on the time in the task bar and select 'Adjust Date/Time'.
 

1 more replies
Relevance 79.54%

Problem: Access table was provided to me with the date fields as integer format (20040625). There are 20 tables with various different date fields in each one.
I need to run various queries that will convert the date into date format (06/25/2004).
I have developed the following formula to do this (the field name was [HireDate]

DateSerial((Mid([HireDate],1,4)),(Mid([HireDate],5,2)),(Mid([HireDate],7,2)))

This returns the correct result and so I know that the query works.

What I need.
I need a module that will enable me to access the formula from within the expression builder and apply the same formula to the various different date fields within the different tables that I may require

Example
table name – T1
Date field name – D1

Your assistance is much appreciated
 

Answer:Access module to convert date

Take a look at this database, the query you need is convertdate, the module is module1 and the Function is Function mydate(Data As String)
 

2 more replies
Relevance 79.54%

Ok, I need a formula in Excel that converts a date field (i.e., 7/29/04) to the name of the day that represents (i.e., Thursday). I don't care what form the day is, it can be text or date displayed with just the day.
 

Answer:Need a formula to convert a date to text

Actually you don't need a formula.

Just format the cell as Custom, with a format of dddd.

That will display only the full day (Thursday), without "destroying" the underlying date data.
ddd format displays the shortened version (Thu).
 

3 more replies
Relevance 79.54%

Working in Open Office Calc 3.0, I need to flag dates, in order to flag they need to be numbers, how do I convert the dd/mm format to the actual number of the day in the year? EX: 1/1 =1, 12/31 =365. Issue is: Input data as dd/mm, display number of day in year.Any help would be greatly appreciated. I need the format set in the cell, if possible.

Answer:Exel convert a date to number: 11/10 to 314

I know there is a better way to this... but you could make a table somewhere that has the date in one column and numbers 1 to 365 in an adjacent column, and then do a vlookup

5 more replies
Relevance 79.54%

I have written date 01.02.2012 in a cell and i want to convert this text date to date format 2/1/2012 or 1-Feb-2012..PLZ help me

Answer:Convert text to date format

Do a Search & Replace.Search for a DOTReplace with a SLASHShould give you a DATE.MIKEhttp://www.skeptic.com/

5 more replies
Relevance 79.54%

I use Win XP/Home SP 2, on a computer with a 900 Mhz Celeron processor and 250 MB of RAM. I have Publisher 2002 installed on the computer.

I searched this forum, but found no posts that talk about this topic. I also searched the Microsoft online help files without success. Lots of info on calendars in Outlook and other programs, but on Publisher. Nothing in the computer resident help files.

I have a Publisher file from a much older version of Publisher. The file is a newsletter, which I update for new issues. In this file is a calendar that is a grouped set of two items; a text box with only the month and year, and the calendar. When you click on this group, a small icon appears at the lower right of the image. When you click on that icon, you start a "wizard" that allows you to update the date range of the calendar.

This is a handy feature. I have tried to figure out how to set this up starting from "scratch." So far, no luck.

Can anyone help?

Thanks.
 

More replies
Relevance 79.54%

I have a document in Publisher that I have modified to my liking, and all I want to do is change the date range. Easy enough, right? Not so much.

The dates that I currently have are October 2007-January 2008. If I change the date to October 2007 to ANYTHING IN THE FUTURE... I don't get the months of February 2008, March 2008, April 2008. The calendar goes from October 2007-January 2008, May 2008 to whatever I specify. I am ready to throw my computer out the window. Any ideas?
 

More replies
Relevance 79.54%

Is there a calendar app that allows you to set a recurring event with begin and end dates, instead of that event going on forever? Would be nice if it syncs with Outlook, too. I can't believe I'm having so much difficulty with this, it seems very basic. I hope there's an answer - I love my 920 and WP in general, but these are the kind of things that cause people to go Android and iOS. And I really can't say as I blame them. Message to Microsoft: Function matters.

Answer:Is there a Calendar app that can do recurring events with a begin and end date

Apparently not.

2 more replies
Relevance 79.54%

What calendar app allows you to set a recurring event with begin and end dates, instead of the event going on forever? I can't believe I'm having so much difficulty with this. This is kind of basic.

More replies
Relevance 79.54%

Outlook calendar shows in correct date after day light savings in Lumia 650,it stills shows Sunday Nov 6 but when I clicked app it shows correct date .Pls advice

Answer:Outlook calendar shows in correct date

I would suggest creating an event for today on your Outlook calendar on your PC and then open your email and hit the sync button. That might work.

0 more replies
Relevance 79.54%

Is there any way of checking when an entry was made into the Outlook calendar, or when it may hav been ammended. Thanks

Answer:Date of entry of Calendar item in Outlook

In Outlook 2007 open the calendar item and then click on the office symbol and the select properties and you will find your information.

3 more replies
Relevance 78.72%

I have a MS Access database that links to a oracle database. The date fields are in UTC from 1/1/70 12:00 am. I have an excel spreadsheet that shows me the conversion such as

8/12/2004 12:00am with adjustment to local time is 1092283200

What I would like to do is create an input form for a query where the user can just put in the starting date and time and it convert it to the equivalent UTC number. Right now they have to go to excel and get the equivalent starting UTC number for the date they want. The query is set up to ask for the starting UTC number using the criteria field [Enter Start number] since that is how the linked database stores it.

I have tried to search the web for how to do this conversion but only find how to convert UTC to Access Date time. When I run the query, I have no problem getting this conversion with expression field of

ConDate: DateAdd("h",-4,(DateAdd("s",[EVENT_START],"January 01,1970 12:00:00am")))

Any ideas on converting date/time format to UTC would be greatly appreciated.
 

Answer:Solved: Convert Date/Time to UTC numbers

I have created a form for Start and End Date (used format of General Date and Short Date). I am using a button to run code as follows to see what I am getting for the txtStartDate but it shows up as 12:00am and not the date entered. Therefore the DateDiff function comes out with -25569 instead of 14256:

Public Sub DateQuery_Click()
On Error GoTo Err_DateQuery_Click
Dim txtStartDate As Date

MsgBox txtStartDate
MsgBox DateDiff("d", "1/1/1970", txtStartDate)

Exit_DateQuery_Click:
Exit Sub
Err_DateQuery_Click:
MsgBox Err.Description
Resume Exit_DateQuery_Click

End Sub
I am hoping it is something simple. Can anyone help?
 

2 more replies
Relevance 78.72%

I need help completing this countifs formula; I need to count the amount of sales that where registered in the current month, I cannot use a helper column because I get a new report everyday and it would not be feasible for me to add the helper column to the new report everyday.How can I first convert the date to the month number so I can compare it against the current month number and add that as a criteria? The part that contains MONTH($S$1) refers to a cell where i am converting today's date to the month number. SalesSheet!$AQ$2:$AQ$999 this is the range where he sales registration date is.Formula:=COUNTIFS(ASD!AS2:AS999,A3,SalesSheet!$AQ$2:$AQ$999,MONTH($S$1))

Answer:Convert a date to month to use in COUNTIFS criteria

Adding a Helper Column can easily be accomplished with a macro. You just need an easy way to have that macro available all the time. I will now offer you that way...If you are not familiar with the personal.xlsm workbook, you should be. 1 - Open a new workbook2 - Place any commonly used macros in this workbook3 - Save the workbook as personal.xlsm in your xlstart folder3 - Hide the workbook4 - Quit Excel5 - Excel will ask you if want to save the changes to personal.xlsm (the hide)6 - Click SaveAny workbook stored in the xlstart folder will automatically open whenever you open Excel. Since personal.xlsm is hidden, you won't even know it's there. However, any macros stored in personal.xlsm will be available for use.I have a dozen or so icons on my Excel Quick Launch toolbar that have macros from my personal.xlsm workbook assigned to them. All I need to do is click an icon and the macro runs on the currently active workbook. This has saved me thousands of hours of manual work over the years.I have one macro that adds a Helper Column (nothing more than a copy of an existing column of data) and also some Conditional Formatting. This helps me keep track of which pieces of data I have updated. When I change a cell in the original data column, it no longer matches the Helper Column value and turns Yellow. After I have completed all of the required updates, I click the same Icon again and the Helper Column and Conditional Formatting rules are deleted. All you need is a macro that know... Read more

4 more replies
Relevance 78.72%

Hi. I have created a sheet where there are multiple users and I have added a calendar (not pop-up....still haven't figured out why it won't work for me). The calendar works fine and the linked cell too.

The thing is....the linked cell format will not change to the way I want it to...it remains as "dd/mm/yyyy". I've tried to format to the date I want using the typical date format but it always stays as "dd/mm/yyyy".

I want it to be dd-mmm-yyyy (18-Jan-2014.

Is there a VBA code that would help fix this?

Thanks.
 

Answer:Form Control Calendar date will not change its format

Johfra,

What version are you using? I was able to create a custom format with dd-mmm-yyyy by using the number format and customizing the d-mmm-yy type.

Stoneboy
 

3 more replies
Relevance 78.72%

Instead of having the date displayed within your calendar view as:

Is there a setting that can be changed so that it reads the day (ie. Friday 4 January) instead?
 

Answer:Solved: Outlook 2003 Calendar Display Day instead of Date?

8 more replies
Relevance 78.72%

The calendar gadget only show a orange background, but not date
I run from the Command Prompt the following
regsvr32 atl.dll
regsvr32 -u wlsrvc.dll
regsvr32 -u sbdrop.dll
regsvr32 wlsrc.dll
regsvr32 scrun.dll
regsvr32 msxml3.dll
regsvr32 jscript.dll
regsvr32.exe vbscript.dll
Only the last two succeeded
I will apreciate if someone can help me to solve the problem
Thank you

Tech Support Guy System Info Utility version 1.0.0.1
OS Version: Microsoft® Windows Vista™ Home Premium , Service Pack 2, 64 bit
Processor: Intel(R) Core(TM)2 Quad CPU Q6700 @ 2.66GHz, Intel64 Family 6 Model 15 Stepping 11
Processor Count: 4
RAM: 4094 Mb
Graphics Card: NVIDIA GeForce 9500 GS, 512 Mb
Hard Drives: C: Total - 703753 MB, Free - 527530 MB; D: Total - 11648 MB, Free - 1106 MB;
Motherboard: PEGATRON CORPORATION, Benicia, 1.01, X312345678
Antivirus: Norton Internet Security, Updated and Enabled
 

Answer:sidebar calendar gadget doesn't show date

I found the problem myself after long searh in the internet.
If somebody has the same problem try installing Java. This solved my week of searching
 

1 more replies
Relevance 78.72%

My calendar in Windows 10 is constantly alerting me that its settings are out of date for 2 accounts. It requests I submit the password to update, which I do, but it never updates and routinely bleeps to tell me I need to update them. This makes the calendar absolutely useless to me (doesn't sync with anything) and is also very annoying.
Any suggestions on how I can fix this please???

More replies
Relevance 78.72%

Hello, I suddenly have no desktop calendar showing when I click on the time and date in the taskbar. There used to be a huge rectangluar thing with a calendar there, but now nothing.

Can anyone please help me with this?
I added a screenshot to show what it does when I click on the date and time... no calendar pops up.

Answer:Calendar not showing on desktop when I click the date and time

I got it fixed. I think I opened the control panel then defaults and then I clicked calendar and set everything back to its default settings.

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%

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%

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

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%

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%

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%

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%

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%

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%

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

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

usually, when I put people's birth date into the 'People' option it updates the birthday calendar in 'Calendar'. But I just came across a case where this did not happen, causing me to miss the person's birthday. What might be the reason that most birth dates copy, but sometimes they don't?

Answer:Why isn't the birthday date from Outlook 'people' option show in 'calendar' (Windows 7)?

It also syncs with Facebook and Skype. And currently especially the Skype integration is known to make a mess of things. I've four birthdays for the same contact in my contact list. The contact doesn't like it when you tell her four times a year Happy Birthday. Apparently.
Perhaps one of the linked networks the contact has set the wrong date. See if you can manually edit this or view this through the outlook.com website.

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

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%

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%

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

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

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