For questions concerned with obtaining, manipulating or presenting the calendar date.

learn more… | top users | synonyms

1
vote
3answers
59 views

Batch script (cmd) resulting in DD-MM-YYYY_weekday format

I need to use date /t command and convert the date format to DD-MM-YYYY_weekday with all the "-" and "_" as listed I can't find an answer on my question. Could you please help me?
1
vote
1answer
18 views

Auto - updated change date in Powerpoint

Is there a way to add date of the last slide change to powerpoint? The date as offered by powerpoint can be fixed or auto-updated, but this updates at each printig/opening. I would like it to update ...
1
vote
1answer
16 views

List folders by date modified

Normally if I want to list everything in the folder by date modified I would type the expression datemodified:‎<16/03/2014 into the search bar at the top. This expression lists everything in that ...
1
vote
1answer
79 views

Adjust creation date/time of files already copied?

I recently replaced my laptop's hard-disk with a bigger capacity SSD. Windows was re-installed from scratch and then I copied my data to the SSD by putting the old hard-disk in an external USB ...
1
vote
0answers
35 views

linux - set date offset from BIOS date

Linux can use BIOS clock in UTC or local time mode so it can add certain offset to BIOS time at OS level. Is it possible to do the same for date? I mean lets say I'd have 1999 year set in BIOS and ...
1
vote
1answer
356 views

MP4 video - Editing Creation Date and Other Metadate

I wish to find out if it is possible to edit the creation date and time of an MP4 video file. I have attempted to do so using ffmpeg with the syntax listed below ffmpeg -y -i "22.mp4" -c copy -...
1
vote
0answers
104 views

Solaris + date + what is the same equivalent for Solaris [closed]

on Linux the syntax for date with seconds is: date +%s 1438587288 from MAN PAGE - %s seconds since 1970-01-01 00:00:00 UTC what is the same equivalent for Solaris?
1
vote
1answer
120 views

How to count months in intersection of two date ranges [closed]

I need to calculate the number of months in the intersection of two date ranges. For instance, in Column A I have start dates of employment 12/1/1998, 1/1/2003, 2/1/1995 and in column B I have ...
1
vote
0answers
48 views

Run Query in Siebel on Modified due date

I want to run a query for open SRs by Modified due dates. I cannot find that field in normal query. Please help me out.
1
vote
0answers
44 views

LC_date like option for excel sheet (possible in libre office)

Windows 8.1, office 2013, english interface - danish region. When working in excel I often paste dates from another application. These dates are in the form Januar 2013. When pasting, it seems excel ...
1
vote
1answer
31 views

How do I have a Date format show in a Formula that is looking up that cell?

I have a formula: ="('"&A6&"','"&B6&"','"&C6&"','"&D6&"','"&E6&"')," And B6 is a date and formatted as dd/mm/yyyy (have tried all forms though) so the ...
1
vote
1answer
57 views

Create a non standard weekly date range autofill in excel

I am working on a monthly spreadsheet of our daily takings. I need one line for a sunday, monday and tuesday but two lines for wednesday, thursday, friday and saturday. I can't seem to hit the magic ...
1
vote
2answers
773 views

How to set date for a specific program?

after june 2008 the game gears of war is giving error and not running. so when I want to play it, I need to change date about 6 years. so I'm curious is there anyway to set the time for a single ...
1
vote
0answers
492 views

How to find out when an audio disc (CD) has been written/burned?

Is there a way/tool to determine the date and time when an audio disc (CD) has been written/burned? I am aware of How to find out when a disc (DVD) has been written/burned? but the accepted solution ...
1
vote
3answers
740 views

Make Excel recognise date in custom format

How can I make Excel recognize a text in the following format as a date and time? I have the following date in on cell: Tuesday, December 3, 2013 1:54:26 PM +01:00 And would like Excel to format the ...
1
vote
0answers
335 views

Change the Default Date setting in Word 2010

I am using Word 2010 and Windows 7. You know how when you start typing a date in Word it will automatically suggest what it thinks you want? Like if I start typing “6/29”, a little grey bubble will ...
1
vote
2answers
3k views

Convert date from Taiwan to Gregorian in Excel

I've got some data from Taiwan in a .csv spreadsheet, but the dates are all in their patriotic calendar like this: 102/06/05 102/06/22 102/07/01 ... I need them in Gregorian format like this: 2013/...
1
vote
2answers
3k views

How to set mergefield to show long date format?

How can I make Word 2012 display German date format in mail merge? { DATE \a "dd.MM.yy" \ * MERGEFIELD } returns 15.02.2012 for today, 15. Februar 2013 however is what I want.
1
vote
0answers
409 views

Change date in a SQL query to reference a cell in Excel

I have the following code that returns the needed data into excel and manually changing the date will change the returned data; however, I'd like to reference a cell with a formula that will make the ...
1
vote
1answer
394 views

Picasa has re-edited all my photos randomly

I use Picasa to manage my photos. I recently switched from a Windows machine to a Mac, so I used an external hard drive to transfer my photos from the old computer to the new. Everything was fine at ...
1
vote
0answers
200 views

VirtualBox guest not recognizing daylight savings transition

I want to test an app's behaviour during transitions in and out of daylight savings time. I therefore want to be able to set the date and time of a VirtualBox VM, (preferably from the Control Panel ...
1
vote
3answers
312 views

check of date with functions lookup

i have input date in sheet1 say in A! 15/07/2010 and in another sheet range of dates with interval of six months in a1 01/01/2010 and in b1 30/06/2010 and c1 15 likewise data is there i want to ...
1
vote
2answers
5k views

I need todays date to auto fill in cell when data is entered into another cell

I would like to have cells C5-C39 auto fill the date when data is entered into cells B5-B39. I have tried to get it to work using =TODAY() but don't how structure the formula. Thanks.
0
votes
1answer
75 views

Convoluted Date Lookup

I found this, which is pretty close, but I don't know VB, so I'm trying to do this with a vanilla formula. First worksheet has a series of tables of unemployment rate: 1 per US state. Each table ...
0
votes
4answers
192 views

Unix script: use of date and use of for

MinuteNow=date +%M; for ((i=2;i<=57;i+=5)) do if [ "$MinuteNow" == "$i" ]; then ************* fi done The problem is for 2 and 7, the date commande output is 02 ...
0
votes
1answer
34 views

Evaluation error in Match function

Can someone please tell me how this could possibly result in an error??? I don't know about you, but that looks like an exact match to me...
0
votes
3answers
208 views

Motherboard makes screeching/beeping sound after replacing CPU cooler

Added on Nov 9: I put the old cooler back in place, as per Keltari's suggestion, and while the sound is much less pronounced, upon close inspection I can still hear it. It may have been there all ...
0
votes
2answers
574 views

Changing date on Ubuntu without sudo privilages

I am trying to automate a time change on Ubuntu 10.04 with a bash script using the date command. The script works, but it requires sudo privileges, however, the user who will execute the script does ...
0
votes
3answers
4k views

Better way to replace timestamp by date when reading a squid log

Tonight i was trying to look at my proxie's lines, and I came up with this, which seems all but KISS. How would you do it simply ? awk '{ trunc=sprintf("%.0f", $1) ;$1="" ; system("echo -n `date +%R ...
0
votes
2answers
521 views

Set Linux date with ddmmyy

I need to set the date of a Linux box with a string I get from a program. This string is formatted as ddmmyy. Is it possible to use that directly or do I need to reformat it first? Currently I have ...
0
votes
1answer
25 views

Return Date from Excel

I need to find the last date an SKU was updated please. There could be blanks or zeroes in the data so I need to exclude them.
0
votes
3answers
165 views

Excel: Check if date has a day

I have cells with dates in Excel. Some dates have dd-mm-yy (e.g. 20-01-15), others just have mm-yy (e.g. 01-15). I want to determine which cells have a day specified by the user. As far as I can tell,...
0
votes
1answer
66 views

Converting non-numeric date to individual month,day, year components, and combining into one cell as datevalue

I have a date that Excel does not see as a value, I parsed out the month, day, year components into three separate cells, and converted to values, and now need to combine them in one cell to be seen ...
0
votes
3answers
209 views

Ask for date on boot (challenge)

Issue An old laptop computer with XP loses date every time it boots. It has no more battery pack so it has to be plugged permanently in to wall. What I already tried Replaced the little button ...
0
votes
3answers
501 views

How to calculate the first occurrence of a given weekday in the next year in Excel?

I need to calculate the first occurrence in the next year of the weekday of the date in cell A1. For instance, if the date in cell A1 happens to fall on a Thursday, calculate the first Thursday of the ...
0
votes
1answer
389 views

How does `date` calculate time zone offset? [closed]

If I set the time zone environment variable: TZ="Foo/Bar", how does date handle different time zones and display the date accordingly?
0
votes
3answers
8k views

Ubuntu clock is wrong and I can't change it (running as VirtualBox Guest under OSX)

I have a strange problem with my Ubuntu Natty virtual machine running under VirtualBox on OSX. One day last week, my clock on the top bar in Gnome stopped displaying the correct time (I'm not running ...
0
votes
2answers
6k views

Converting date format in formulas in Excel

I have a column of dates in the following format ddd mmm dd hh m:s "EST" yyyy. In another cell in another sheet, I wish to have the dates in the format dd/m/y. How can I do this? I already tried the ...
0
votes
2answers
159 views

CSV opens in OpenOffice but adds slashes?

Trying to open a CSV in open office - but it alters the data. Here is the the CSV in its raw format (opened in Notepad); 10-1001,product name 1, 10-1001-020,product name 2, 10-1001-030,product name 3,...
0
votes
1answer
28 views

When I enter a date it will only insert the sample date

I have tried entering the date by right click "insert date" and choosing mm/dd/yy when I hit enter the date appears as the sample date and I can't get the current date to appear.
0
votes
1answer
20 views

Excel: conditional formatting with with complex function AND

I have a sheet that looks like this: So I have a list of documents to create, and I mark "1" on the column with the month in which I have created them. Now I've been asked to put "1" also as a ...
0
votes
2answers
43 views

How do I change date origin in libreoffice writer?

I am copying a chart from a Calc file to a Writer file. The Calc file has a date origin of 1904. When I copy the chart to the writer file, all the dates get shifted because the origin is (I suppose) ...
0
votes
2answers
35 views

extract in same column cell with different format

I need to extract value in same column that have different format (date and text) as showed below: 09/02/80 23/12/73 ANA ANA 11/03/83 11/03/83 07/07/34 How could obtain from one column two ...
0
votes
1answer
399 views

date and time can't be changed windows 8.1

I need to change my date to something wrong for some reasons. I get no errors and there are no other problems and I can see the change in the left-bottom corner, but after just after a few seconds or ...
0
votes
1answer
30 views

EDATE minus 6 minus 6 is not same as -12

Is there some way to get 2014-06-30 minus 6 months to be 2013-12-31 rather than 2013-12-30 (i.e always end of month)
0
votes
1answer
29 views

Using ntp across LAN

I have 3 debian computers connected to a network switch across LAN without WAN access. I would like to manually set the date and time on one of the computers, then automatically sync the time to the ...
0
votes
1answer
114 views

LibreCalc Date-function returns wrong month

I have a spreadsheet with three columns for "Date", "Currency", and "Amount". Date Currency Amount Month 06.02.2015 EUR 188 March 30.01.2015 EUR 285 January I ...
0
votes
1answer
1k views

NTPD not updating time date on CENTOS

I have set up ntpd on CENTOS, I am trying to get it to pull time from a Windows domain contoller if i run the command: ntpdate dc3.mydomaain.local this works fine and updates the host with the ...
0
votes
1answer
123 views

Tar archive wrong creation date

I have a script to backup some directories: tar cjf /backup-`date +\%m-\%d-\%Y`.tar.bz2 mydir >> /dev/null 2>&1 At the end of the process, a "ls -al" show something like: -rwxr-xr-x 1 ...
0
votes
3answers
15k views

CountIf Formula that counts cells containing any and all dates without having a date range?

I need to simplify a CountIF formula. Instead of having a date range I just need my COUNTIF to count cells cointaining dates disregarding date range period. I have tried for example simplifying it ...