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

learn more… | top users | synonyms

2
votes
1answer
330 views

How to change date format in multiple text files in powershell?

Hello I have around 5000 text files (TXT) in one directory.Files are comma delimited. What I'm trying to do is to change date format (it is stored in first column of each file) from M/d/yyyy to ...
2
votes
1answer
88 views

In zsh the date format for names isn't displayed properly

I don't know what's wrong or if I'm stupid or something, but I just can't get to display the date with words :( I've been trying this for hours now.. It should display Mon, but it displays a "M" ...
1
vote
1answer
13 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
58 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
1answer
314 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
1answer
29 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
8k views

Change All User short date format in Windows 2008R2 using script

I have hundreds of users in Windows 2008 R2. How can i change these user's Regional setting's short date format to DD-MM-YYYY using script ? Thanks
1
vote
1answer
393 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 ...
0
votes
1answer
14 views

CreationTime and LastWriteTime

My wife copy photos to a smartphone. The pictures are 20160403_145233.jpg are called, are the first of 2012/03/10 But The creation date is 04/14/2016, date of transfer. What she sorts the photos by ...
0
votes
1answer
29 views

Excel Pivot Table - How can I return a date in the row value?

I have raw data that includes hundreds of employees who have completed many different training courses and I am needing to insert a pivot table that shows the course name as the column labels, the ...
0
votes
1answer
40 views

Can the MS Word Date Picker force the user to enter a date?

Seems you can type anything you want into a date picker field. Is there a way to force the user to enter a valid date in the proper format (dd-mm-yyyy vs mm-dd-yyyy)
0
votes
1answer
79 views

How do I get the day of the week back on my taskbar on windows 10?

How do I get the day of the week back under the date on the taskbar? It used to be there automatically on windows 7 when I moved the taskbar left and increased the width. Not on Windows 10 though. Any ...
0
votes
1answer
29 views

solaris + how to verify if file isn’t update more than XX min

how to verify if file isn’t update more than 55 min? For example, the file IOstatDisk2.log not update since 18:00 And now the current time is 19:00 solaris1a:/var/tmp ROOT # ls -ltr IOstatDisk2.log ...
0
votes
1answer
1k views

Add Date-Time Stamp To Copied File using Windows Batch

I thought this would be simple but it seems more of a challenge than I thought. I want a file to be copied and pasted with a time stamp appended. I get the time stamp using this code: set ...
0
votes
1answer
93 views

Open Office Calc - Stop date autoformatting

When I paste raw data into calc some of it converts to a date automatically (it is not date data, it simply contains a hyphen). This data is then lost because if i turn it back into text I get an ...
0
votes
1answer
142 views

Looking for a formula(s) that will return the next date (higher than the starting date) from a row of dates, then the next date from that one

Worksheet 1 lists all of the "legs" flown by our aircraft. The leg or legs for each day would then go to Worksheet 2 for Day 1, Worksheet 3 for Day 2, and so on. Legs are listed in columns starting ...
0
votes
1answer
478 views

hardware clock is set but date command is displayed wrong date and time

I am setting date with settimeofday function my hardware clock is set perfectly but when i execute date command it shows me wrong date and time. but if i reboot the system than it show me proper ...
0
votes
1answer
260 views

getting todo.sh to sort due items first, then by priority

How can I get todo.sh to put items that are due: today first, then after that sort the normal way (A-Z priority then everything else)? There's this solution, but then you lose A-Z priority and have ...
0
votes
1answer
38 views

Excel opens asking for a date

I am creating a spreadsheet that needs to ask the user to input a date upon opening the workbook. The answer field needs to include a valid date range that goes back 13 months. Once a valid date ...
0
votes
1answer
90 views

How to delete days with no data?

I have the flow data for 49 years for 15 min interval. I've used pivot table to get the daily average value of flow. After copy-pasting from pivot table and using filter to remove the blank flow ...
0
votes
1answer
51 views

Using Excel to create a date series for a job on the same 2 days every week

I want to create a calendar showing ONLY all the Wednesdays and Thursdays in a year with their date, so for example: Wed 25 Sept Thu 26 Sept Wed 2 October Thu 3 October etc. I thought it would be a ...
0
votes
1answer
3k views

System date change tracking in windows xp

I wanted to track when system time was changed in a PC.By looking at event viewer for event id 520 i will get it. But when i changed date manually in windows and look at event viewer i found 4 entries ...
0
votes
1answer
62 views

Add rows to insert dates from a “from” and “to” column

I want to breakdown an Excel sheet by having it in a specific format. Right now, the sheet is like this FROM TO TOTAL 01/27/12 01/27/12 1 03/09/12 03/09/12 1 04/11/12 ...
0
votes
1answer
702 views

ms sql select data after specific date of the year regardless of year

I want to select a data from column 'Birthday' which format is 'yyyy-mm-dd 00:00:00.000' but I need to skip year, and pull out data from range yyyy-01.01 to yyyy.05.01 ? Tryed underscores and percent ...
0
votes
1answer
50 views

Show the date on pictures

I have pictures, each with a date-taken tag. How do I "stamp" that date onto the picture? (For example editing the picture, putting the date onto the actual picture, not just an overlay...)
0
votes
1answer
1k views

Getting the week number based on date with different first day of the week in gawk

How to get the week number in linux using gawk with different first day of the week? the date command can give me the week number with +%V but it is based on Monday (1-53) or +%U (based on Sunday, ...
4
votes
0answers
68 views

Historical reason why date's %h and %b format codes produce the same output?

Is there a historical reason why date's %h and %b format codes produce the same output? $ echo $(date +\%h) Mar $ echo $(date +\%b) Mar Other redundancies exist in date format codes as well, but ...
2
votes
0answers
129 views

Wrong installation date and size in Programs and Features

Nearly every fourth installed program in this list has an estimated size of 7,04GB. Also for some the date gets updated every day. The corresponding reg keys were all set to "0x0070caf9 (7391993)" ...
2
votes
0answers
136 views

Date types management mismatch (2-digits year) - on copy/paste user action

I find a strange inconsistency when copying-pasting dates on MS Excel, when they have a 2 digits year. I work on a machine Windows 7 Enterprise 64 bit and my Excel is a 2010 version. PROBLEM ...
1
vote
0answers
34 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
0answers
46 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
43 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
0answers
459 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
0answers
330 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
0answers
397 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
0answers
197 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 ...
0
votes
0answers
37 views

Wrong date format in IE 11 but correct in Microsoft Edge

In IE 11 the date is shown as English US (04.26.2016) In Edge the date is shown as Icelandic (26.04.2016) I also changed the language options in IE 11 but that didn't help. Why are the browsers ...
0
votes
0answers
16 views

Count number of minutes in each hour of a period defined by start and finish times in excel

I have a big number of records in excel which have a start date/time and an end date/time Event name Started Ended Event1 25/3/2016 01:55:10 25/3/2016 06:15:50 ...
0
votes
0answers
55 views

how do i filter by a rolling date range from a sql query

I am trying to filter a query by a date range, but a moving date range. I have heard (read on this site) that this can be handled in a formula in excel, but I couldn't really follow the formula that ...
0
votes
0answers
33 views

Why won't `date` accept it's own default output?

On my system right now by default date outputs: $ date Fri 29 Jan 22:04:26 GMT 2016 However if I try to feed dates of this format back into date it results in "invalid date": $ date -d "$(date)" ...
0
votes
0answers
48 views

Google: reverse search image by date?

Each time I try to combine the two I fail, yet this would be great to find the original version of an image. For time range: ...
0
votes
0answers
17 views

Is there any way to set up an iTunes smart playlist that depends on the real time?

I love Christmas music! In November through January. I want my iTunes Smart Playlist to include my Christmas music (Already stored in a separate Smart Playlist (here's my filter)) from November ...
0
votes
0answers
18 views

Office Word template date fields

In a Word template I am using date fields, just like this: Document valid from {CREATEDATE} until {CREATEDATE + 15 days}. It should render, for example: "Document valid from 06/10/2015 until ...
0
votes
0answers
15 views

How to elegantly log working times by file changes

I would like to get to know some (windows) program, or some scripting lines, that could help me to get a chronological list (in the form of a text file) of file changes, on a drive or directory, ...
0
votes
0answers
71 views

Robocopy files only with a certain date

I am looking to copy files from x: to z: only if the destination file has a date changed of 9/23/2014. If the destination file has an older or newer date, don't touch it. X is my backup and Z is the ...
0
votes
0answers
44 views

My sent email is contains the current computer date for no reason

Everytime I tried to send an email through Gmail in Firefox, at the end of the e-mail, appears the current date in the format of YYYY-MM-DD HH:MM Timezone First Name Last Name Email Address: So ...
0
votes
0answers
243 views

Sudden change of date in windows 7 (From 2013 to 2039)

I was watching a video on youtube (using Chrome, OS is windows 7) when a pop up warned me that I had to calibrate my monitor again since the calibration was too old. This sounded strange, since I had ...
0
votes
0answers
303 views

Copying From Windows to NFS: Can The Timestamps Be Preserved?

We have a Linux server that has NFS shares. Some Windows hosts (XP & 7) connect to it via Services for UNIX. I've been told the behavior is different from XP to 7 in terms of file creation dates ...
0
votes
0answers
243 views

Why does exiftool make the current date and time shift?

When I try to shift the date and time using exiftool on both OS X and Windows I get the same outcome: the current date and time changed instead of adding 2m 18d 11hr 14m 0s. exe file and command run ...
-1
votes
0answers
17 views

Mac OS X Mavericks isn't showing month in calendar or time window

So I have tried almost everything I can think of besides just doing a clean install. I don't have a close backup without going back to December (my fault). I tried upgrading to El Capitan which ...