The date tag has no wiki summary.
0
votes
1answer
35 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
0answers
23 views
Add date shortcut in Notepad++ [duplicate]
In Windows regular Notepad, clicking F5 shows the date (according to region format):
09:36 29/04/2013
Is there a shortcut in Notepad++ to achieve it?
Preferably with no plug-in involved, but ...
0
votes
3answers
94 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 ...
0
votes
0answers
38 views
Create a folder with current year & month, windows command line? [duplicate]
How to use mkdir to create a folder with this something like --> folder1-2013-04 (but the year and month should be dynamic and generated automatically.
0
votes
1answer
55 views
Windows batch get current date not working correctly [closed]
I have a problem getting the current date.
Yesterday it worked fine, but today the clock went forward 1 hour.
I am getting the current date in this format:
""2--3--4.01""*
by running the following ...
0
votes
1answer
87 views
Batch script or set of commands to extract the fields of date
I am trying to create a batch file to backup my data at regular intervals in Windows using a batch script.
I need date parameter and the fields from the displayed format (Month, day and year). ...
0
votes
1answer
163 views
In Lotus Notes how can you change the date format?
In Lotus Notes 8.5 how can you change the date format? I don't like 27/3/2013 and would like Wednesday 3, 2013 or the like.
1
vote
2answers
124 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 ...
0
votes
0answers
89 views
OpenOffice Calc - incorrect converting to date format
I have problem with OpenOffice Calc...I need to work with many values of date/time in text format "D.M.YY H:MM", for ex. today 13.3.13 12:30 ... But if I try to format this strings like Date, it ...
2
votes
1answer
69 views
1
vote
2answers
141 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.
0
votes
1answer
102 views
monthly totals comparing two date columns, Excel 2010
How can I calculate a monthly total of the courses completed for the month ONLY when they were due for that same month (sometimes students are late and sometimes early)?
The spreadsheet has a column ...
1
vote
1answer
170 views
What format can I use in Excel to display both date and time in system formats
I need to display both date and time in system date and time formats.
I know that [$-0xf800] means the system long date format and [$-0xf400] means the system time format, but [$-0xf800][$-0xf400] ...
0
votes
1answer
143 views
EXCEL populate a list of sunday's dates and ignore the sundays in an exception list
Hi i'm working on a sheet which i have to populate with sundays dates, and make sure that dates from an exception list don't be present in my final list
Goal: is to have the list of dates of only ...
0
votes
1answer
158 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 ...
1
vote
1answer
166 views
My windows explorer shows future dates for date modified
My windows explorer shows dates like tomorrow, next week and even later this year when grouping my files with date modified. What is going on?
1
vote
0answers
101 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
832 views
How can I change the default date format?
When I paste a date into Excel 2010 in the format "2012-12-07 00:00:00.000" I'd like it to be displayed by default as "2012-12-07", but it is actually displayed as "00:00.0".
I know I can work ...
2
votes
1answer
546 views
How do I get the current date according to an NTP server without setting it locally?
I want to get the current date and time according to a remote NTP server, using Linux. I don't want to change the local time as a result; I just want to get the remote date, adjusted for the local ...
0
votes
3answers
397 views
How autofill all rows between two dates in excel with the second date as the incrementing limit?
That title might have made my issue sound more complex than it is...
I am trying to figure out take one cell.... say A1 and put a date in it.... then move down several thousand rows and give another ...
0
votes
1answer
346 views
linux “date -s” command not working to change date on a server
date +%T --set="12:19:06"
12:19:06
date
Mon Nov 26 12:37:32 SAST 2012
date 112613232012
Mon Nov 26 13:23:00 SAST 2012
date
Mon Nov 26 13:42:27 SAST 2012
I have tried many different forms of this ...
1
vote
3answers
157 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
1k views
In Excel 2010 why can't I change the date format?
The original date is in the following format:
14/Nov/201110:53:44
I need it in this form:
14.11.2011 10:53:44
When I choose Number -> Custom -> d.m.yyyy h:mm -> OK , nothing changes.
...
0
votes
1answer
94 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?
1
vote
1answer
190 views
How can I batch shift the creation date of files on OS X 10.6.8?
Please note that I am not asking how to change the creation date of a bunch of files to a given date. I want to shift the date by a given amount of time, for example 47732400 seconds.
Can I ...
0
votes
1answer
37 views
How do I search for a fixed date field in OpenOffice Writer?
Apache OpenOffice.org writer 3.4.1.
I have a large file with many fixed date fields. (Menu: Insert/Fields/Date, and/or AutoText from such a field.)
How do I search by field value? The Find (Find ...
0
votes
2answers
188 views
Formula to calculate the 5th [day of the week] when applicable
I've used the following formula to get the nth xday of the month:
=DATE(B2,A2,1+7*n)-WEEKDAY(DATE(B2,A2,8-xday))
where year is in B2 and month (as a number from 1 to 12) is in A2, and where xday is ...
0
votes
2answers
128 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 ...
1
vote
1answer
294 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?
3
votes
2answers
189 views
Edit date field code on multiple Word Documents
I have multiple word documents that have a date field code displaying the current date. I need a way to modify each document so that it shows the CreateDate field instead of Date.
The format for each ...
0
votes
1answer
146 views
Display date serial number using TEXT in IF
I am using an IF function to insert a string into a cell if the cell specified is #N/A, the function works if I use the following
=IF(AS2="#N/A","",CONCATENATE("insert in tempTable ...
1
vote
1answer
85 views
Excel Date Formula with a condition
I have 3 fields in excel as follows:
Cell A1=2012 A2=12 A3=15 which contains year, month & date value respectively. And I want to make a date string out of it.
I know it's very easy to achieve ...
2
votes
2answers
1k 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 ...
0
votes
1answer
99 views
Identify date/time format
I've been given some data to create some chart graphics and the dates are in a format I don't recognise. If I knew the format name I could easily look them up but initial search has drawn a blank. ...
0
votes
1answer
106 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 should contain the current date. ...
1
vote
1answer
986 views
Open Office Calc: Convert a date to timestamp
I have a column with dates in M/D/Y like this:
8/8/2007
8/9/2007
8/10/2007
8/13/2007
8/14/2007
8/15/2007
8/16/2007
I would like to convert them to a unix timestamp (in a new column). Would anyone ...
3
votes
1answer
437 views
Importing specific date format to Excel from Microsoft SQL Server
I've already asked the question at: StackOverFlow and got sent to this place here.
I'm importing dates from a German SQL Server table into a German Excel file via the built-in Excel connection tool.
...
1
vote
1answer
227 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
2answers
131 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 ...
7
votes
4answers
475 views
Put a text in front of every new line that a program prints to stdout
So I want to do some logging and therefor, want to put a date in front of a bash script's output. The problem is that is has multiple lines of output. I am able to only put the date before the whole ...
0
votes
0answers
941 views
Excel conditional formatting, greater than a year
I am working on a spreadsheet that logs the dates parts were sent out and would like to apply conditional formatting to the dates.
I would like if over 3 years ago, if over 2 years ago, if over 1, ...
13
votes
3answers
323 views
How to insert the date into vim
In vim you can execute comands with "!". You can combine that with "r" to insert the output into your current buffer.
:r!date
Fri Jul 20 09:39:26 SAST 2012
will insert the date into a file. ...
1
vote
0answers
83 views
ms excel 2010 in windows xp - when open workbook the data is formatted differently than when i saved it
I haven't been able to find an answer to this.
I have multiple files that I use regularly in excel that now have cell formats of "date". Every single cell in the entire workbook (all sheets) is ...
0
votes
0answers
127 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
1answer
349 views
How can I convert LDAP Timestamps in Libra Office to a date time format
If I query the directory, I get the following results.
ldapsearch2.4 -x -b "dc=localhost,dc=com" "cn=auser" "+" | grep stamp
createTimestamp: 20100407122221Z
modifyTimestamp: 20100407122221Z
...
1
vote
2answers
130 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
|
...
2
votes
2answers
545 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 ...
2
votes
0answers
68 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" ...
0
votes
0answers
68 views
Disabling relative dates (today, yesterday, Thursday, etc) in JIRA?
I'm stuck using JIRA at work, and am endlessly frustrated by its inconsistent use of relative dates ("Created: Thursday 10:07 AM" vs "Due On: 31/May/12" -- where Thursday was May 31, etc). Is there ...
-1
votes
1answer
1k views
Calculate age in days/months/years in OpenOffice
In need to find the age in days - months - years in OpenOffice.
There is DATEDIF() in Microsoft Excel. You can use it to find the difference in days/months/years between two dates.
Age Calculation
...
