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

learn more… | top users | synonyms

2
votes
1answer
1k views

Why does Windows date jump a month ahead

We have a few computers that run Windows XP and every now and again they put the date/time one month forward in time. This just happened again today, putting the date to 20th September 2010. This is ...
2
votes
1answer
518 views

Batch adjust / increment file date by an offset?

Suppose I have a folder of 100 files, and they have created/modified dates that are wrong, because the real-time-clock in the device that wrote them was wrong. I want to add the same offset to the ...
2
votes
4answers
490 views

What other archive formats save Date Created and Date Accessed?

7-Zip on Windows will save the Date Created and Date Accessed when compressing a .zip file, however it does not do this for its (referring to 7-Zip) native .7z format. Any Unix-based formats are ...
2
votes
2answers
7k views

How do I copy recent folder/files from a network drive using a batch file?

My question may have answered someway or other but unfortunately I did not get the exact answer that I was looking for. Here is what I'm trying to do- create a folder on pc1, c:\temp1 map a network ...
2
votes
1answer
2k views

why do some emails have impossible (past) dates?

I just got a spam email dated 1970/1/1. I laughed, but then thought about it a bit more. I get these from time to time - always spam - and assumed they did this to stand out in your inbox. But I'm ...
2
votes
3answers
6k views

Difference in command line date format between XP & Windows 7

The DATE command in XP gives the date in the format ddd dd/mm/yyyy e.g. Sun 12/12/2010. In Windows 7, it only gives dd/mm/yy I.e. 12/12/2010. Both have the same regional settings. Can Windows 7 be ...
2
votes
3answers
3k views

How to get date value in commandline

I need to do a command that takes yesterday date and builds it into a file path like this: copy "Something 2010-12-06\*.zip" "d:\Copy\" where 2010-12-6 is yesterday's date in format yyyy-mm-dd. ...
2
votes
2answers
755 views

How to fix iCal wrong date after snow leopard upgrade? [closed]

I searched google everywhere but could not find a fix for that annoying bug. This video shows exactly what happens: http://www.youtube.com/watch?v=hsie6lN0p8o Removing from the doc and re-adding ...
2
votes
2answers
970 views

Convert Month Number to Month Name

Is there a way to convert month number to name with a script? example: 2013-10-22 will become Oct 22 Thanks. BTW, I don't have the GNU date and my OS is AIX.
2
votes
1answer
425 views

How to set-up date for cron weekly backup?

I'm writing a command for cron to do automatic backups for my flashdrive. I use tar ... -N <some date> to make the backup. The issue is how to write the command which gives me the right date. ...
2
votes
1answer
342 views

Make folders' last modified date correspond to last modified date of its child folders/files

I am working with FileZilla to locate the last modified files of my website. I thought the last modified date of a parent folder will correspond to the latest last modified date of its children files ...
2
votes
3answers
2k views

unable to use datediff function in apache openoffice calc

I am unable to get a result by using this command =DATEDIFF('dd', '2007-08-01', '2007-09-01') in apache openoffice calc. Even using two columns of dates and using the formula =DATEDIFF('dd','A2','B2')...
2
votes
0answers
163 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
1answer
339 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 MM/dd/...
2
votes
0answers
143 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 ...
2
votes
1answer
89 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" ...
2
votes
2answers
266 views

Vista: change clock tooltip to short date?

Is it possible to change the tooltip that shows above the clock from the "Long date" format to show the "Short date" format?
1
vote
1answer
3k views

How do I write a batch script to generate folders for each month, day and year?

How do I write a batch script to generate folders for each month, day and year based on user input?
1
vote
3answers
795 views

how to change the time format in Linux system

My Linux system has time format of UTC-5:0. How can i change it to UTC+5:30? Using date command i can able to change the time, but not the format
1
vote
3answers
474 views

Linux date command is 4 minutes slow

I installed Centos onto my server and I noticed that when I compared the date command's output to time.gov (same timezones, of course), the output was 4 minutes behind. This also affects my ...
1
vote
1answer
360 views

On the command line, 'find' reports back an illegal time value

I want to run the following command. find . -mtime -60s When I do, I get this output instead: CLIENT% echo `date +%s`-1308741881 | bc 5152 CLIENT% find . -mtime -`echo `date +%s`-1308741881 | bc`s -...
1
vote
2answers
2k views

Unix Date command not working for few servers

I am trying to execute date command in unix server for yesterday. The commands tried are : date --date="1 day ago" date --date="1 days ago" date --date="yesterday" date --date="-1 day" These ...
1
vote
1answer
38 views

Search unix drive for file modified today

Is there a way I can search an entire unix drive for a file that was modified today? I realize this could take a while, but thats not an issue
1
vote
3answers
1k views

How to Change Server Date?

How do I change a Linux web server's date through SSH?
1
vote
1answer
167 views

How do I create a batch file that will create a folder for each day of the month? [closed]

At the beginning of each month inside a directory, I need to create a folder for each day in that month (in the format of DDMMYYYY). I'd like to just run this script on the first day of each month ...
1
vote
2answers
447 views

Proper date -d “next monday”

I'm trying to write a quick script that figures out the date of the next Monday that isn't today. Although the date command accepts this expression, it appears to interpret it as equivalent to "this ...
1
vote
2answers
1k views

Creating a column of working days in LibreOffice Calc

In LibreOffice Calc, I would like to create a column of working days, for example: [...] 2012-01-30 [Monday] 2012-01-27 2012-01-26 2012-01-25 2012-01-24 2012-01-23 [Monday] 2012-01-20 2012-01-19 2012-...
1
vote
2answers
706 views

Excel macro date parser cannot handle single-digit days

From previous questions on this and other sites I was given a function that can parse for and find dates in text strings or cells. Here's the function: Function GetDate(strInput As String) As Date ...
1
vote
3answers
42 views

Sort by `ls -l` Dates Without Using `ls`

I have a text file with a bunch of ls -l output, such as: -rw-r--r-- 1 root root 7554952082 Dec 15 22:11 /var/spool/stuff/Investigation/messages.tgz -rw-r--r-- 1 root root 4315 Mar 3 2015 /var/...
1
vote
1answer
216 views

LibreOffice: Autocomplete dates with month and year, no day

I'm using Libreoffice 4.4 and I want to drag down a column in format Month Year. For example: May 2015. I do not need days. I tried to drag down after doing this schema for 3 cells but it doesn't ...
1
vote
2answers
1k views

Shell Script User Input Date Validation

How would I go about performing date validation on user input in a shell script? I want to notify the user if they enter the date in the wrong format. The correct format would be YYYYMMDD.
1
vote
1answer
177 views

Trouble in set the date in windows xp only after 8/2008

I'm having trouble setting the date in Windows XP. Specifications: Microsoft windows xp professional 2002 Service Pack 2 Intel Pentium 4 CPU 2.90 GHz RAM 512 MB Every time I try change my date ...
1
vote
1answer
2k views

PowerShell touch all files newer than

I have found the following question on ServerFault: Windows recursive touch command Which partially answers my question with this answer: Windows recursive touch command However, I would like to ...
1
vote
2answers
212 views

A download manager for Linux which saves downloaded files in directories by date like 2012_06_29

I've been using Download Master on Windows for years and what I liked most about it is that this program can automatically put downloaded files into directories by download date: /Downloads | |-...
1
vote
1answer
3k views

How to tell when RedHat was last updated

I have a RHEL 5 server and I want to know the last date in which it was updated. Is this technically feasible? If yes, how?
1
vote
1answer
279 views

Inaccurate dates displayed in Excel (dates being calcuated from 1904 instead of 1900)

I have an excel spreadsheet containing a column of dates. When data is copied from other spreadsheets into this spreadsheet the dates change and become inaccurate. Changing the format of the ...
1
vote
1answer
19 views

How can I complete a PDF form with Adobe Acrobat Pro so that I can use ISO 8601 (i.e., yyyy-mm-dd) to input date field?

How can I complete a PDF form with Adobe Acrobat Pro so that I can use ISO 8601 (i.e., yyyy-mm-dd) to input date field? By default, it's mm-dd-yyyy or mm-dd-yy: I use Adobe Acrobat Pro XI with ...
1
vote
1answer
81 views

Linux tar files within specific date range using filename date

I have files whose names begin with YYYYMMDD like the following: 20160221_143223_Report.csv 20160222_121223_Report.csv ... 20160229_141223_Report.csv 20160301_171223_Report.csv I want to ...
1
vote
3answers
96 views

How to insert the date as quarter in Word 2010?

In Excel the quarter can be calculated by using a formula. How about in Word 2010? Is there a way to insert the current quarter such as "Q1-2008"? It should be an auto-updated field such as the ...
1
vote
1answer
55 views

Excel, Differences within Day for Multiple Dates

Im currently facing a problem trying to find variations in a Database as follows: > Date | Hour | Place 1 | Place 2 | Place 3 ... Place K (about 50) >----------------------------------------...
1
vote
1answer
134 views

Date command - adjusting the date works on my mac but NOT the server's shell

On my mac I can ask for the date in threes days time: Josephs-MacBook-Pro-3$date -v 3d Fri 3 Oct 2014 08:54:26 BST Josephs-MacBook-Pro-3$ but when I try that on my dreamhost server: ...
1
vote
3answers
24k views

How to convert dd.mm.yyyy date format to yyyy-mm-dd in Excel 2007?

My customer entered date in dd.mm.yyyy format. As I want insert all the data in mysql database, I want the date in yyyy-mm-dd format. I tried to format using Excel custom date format and built-in ...
1
vote
2answers
5k views

Convert Day of the Year in Excel?

How can I convert Day of the Year to a mm/dd format in Excel? Date of the Year: e.g. 1= Jan 1, 177 = June 27. For example, how do I convert "177" to 6/27?
1
vote
1answer
671 views

How to use the current date as an argument?

I have a batch script which extract SQL data to CSV file: bcp Database.dbo.MyTable out C:\Reports\Output.csv -s ServerName -T -c I need the name of the output file to contain the current date. For ...
1
vote
2answers
4k views

How to override date format in regional and language options?

In Windows XP, it's not possible to display the date format in DD/MM/YYYY, because it wasn't available in the regional and language options. The following image will illustrate my problem. So ...
1
vote
1answer
1k views

How to change time (Advanced Eastern Time) on Slackware 8.1

I have a linux (Slackware) machine and the time/date is like, June 23rd 2003, 10:00am (It's 11 here) and I am not able to set the time to have it correct. I change the timezome to Montreal but the ...
1
vote
2answers
32 views

sql - year day to day/month conversion

suppose I have the following table +-----------+-------------+ | DAY | LEAP YEAR | +-----------+-------------+ | 7 | true | | 167 | false | | 43 | true ...
1
vote
3answers
50 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
16 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
14 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 ...