Questions tagged [date]

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

Filter by
Sorted by
Tagged with
0
votes
0answers
15 views

Formula to see if a date is before, during or after a specific date range

I am trying to see if a date is before, during or after a specific date range. For example: A1 16/01/2020 A2 01/01/19 B2 31/12/19 A3 01/01/20 B3 31/12/20 A4 01/01/21 B3 31/12/21 I need a formula ...
0
votes
0answers
24 views

Why is the Date column sometimes the Date Taken column, but 12 hours ahead?

In an effort to find an answer to my other question, I came across this unusual behavior. Sometimes the Date column is a copy of the Date Taken column, down to the minute, but exactly 12 hours ahead. ...
0
votes
1answer
57 views

How to bulk rename files in a directory using the Date column

I've got a list of a few hundred files that I need renamed by appending a modified version of the Date column to the front of the file name. The tricky part is the use of the Date column. I've tried ...
0
votes
0answers
33 views

Why is 1st January 2020 formatted strangely in Excel Pivot Table?

I have a pivot table report containing data for 1st-7th January 2020 with date being used as row names. In the raw data, the dates in the data themselves are all formatted like 01-JAN-2020, 02-JAN-...
1
vote
1answer
44 views

Date format to string in ddmmyyyy

So I am working on an existing workbook so I cannot change the layout unfortunately. In the first sheet, a function automatically returns today's date in the "yyyymmdd" format. On another sheet, that ...
2
votes
2answers
1k views

How can I place a date in dd/mm/yyyy format into an Excel cell with VBA?

I want to fill a cell in a worksheet with the date as string and I want it to be in the dd/mm/yyyy format. I use the following code but it keeps showing as mm/dd/yyyy. I'm not sure what I am doing ...
0
votes
1answer
32 views

How should this datetime format be interpreted? “20190328012019.000000+120”

20190328012019.000000+120 That's the weird timestamp outputted by WMIC commands on Windows. I assume that 2019 is the year, 03 is the month and 28 is the day, and that 01 is the hour, 20 the minute ...
0
votes
0answers
24 views

Have multiple calendars in Win10

I have enabled Solar Hijri calendar in date & time settings on my Windows 10 PC. Is there any tool or trick to enable Gregorian as a second calendar and have multiple calendars at once? (Just like ...
0
votes
0answers
35 views

How to separate Windows taskbar short date and explorer short date

It seems like an immensely specific request, but I would like to make it so my taskbar shows the short date (like it does in the attached photo), but file explorer will show the long date when using ...
0
votes
1answer
10 views

How to include more dates on my x axis

I’m having issue to include additional dates on my x axis. Usually I’d select data, edit my horizontal axis label to include more dates. (2nd pic) But it’s not showing up on my graph. (1st pic) I also ...
1
vote
1answer
72 views

Excel not properly comparing dates, despite same cell format

I have two date rows. Both are formatted as dates. When I do a logic test to see whether the two dates, excel is not recognizing them as the same. Here is a screenshot of the cells: This is to ...
0
votes
1answer
16 views

command date not respecting timezone

I'm in git-bash on Windows 10 : ~$ locale LANG=C LC_CTYPE="C" LC_NUMERIC="C" LC_TIME="C" LC_COLLATE="C" LC_MONETARY="C" LC_MESSAGES="C" LC_ALL= ~$ date --version date (GNU coreutils)...
1
vote
1answer
31 views

Excel count numbers, with taking day of today in account

I have an Excel sheet that looks like this: In the column "Total" I have the total amount of minutes that need to be executed. In the days after the "Todo" column I have the number of minutes that ...
0
votes
0answers
5 views

MS Project print preview does'nt fit the required timescale range

In the print preview display of MS-Project, you have the SETTINGS where tou can choose the timescale range inside which you want the gantt to be displayed. If you choose the option "Print specific ...
0
votes
0answers
9 views

Date command not working properly for America/Bogota timezone

On RHEL 7.2 I have set the timezone to "America/Bogota (COT)" With that, if I execute date command it works fine, But if I try to get the UTC timestamp for given timestamp where the timezone is Bogota ...
0
votes
0answers
17 views

change modification and create date for word file mac os catalina?

Hi there I was looking to change the create and modification date for word file I have used the touch-t command on terminal but when i send the document and open it it reverts back to original date!
1
vote
2answers
71 views

Is there any way to view dates of changes to Windows registry keys/values?

Is there any sort of date tracking that is done or viewable in the Windows registry, such as seeing the date when X key was created, or Y key was modified, similar to how file systems track? I'm ...
0
votes
1answer
35 views

Counting the occurence of active durations by month and into a graph

Lets assume I currently have a spreadsheet that holds the dates of members at a crossfit gym and the duration of their memberships. Date Started Date Ended Member Name 11/27/2019 12/19/2019 ...
0
votes
1answer
57 views

How to add fractional year to date in Excel?

Is there a way to add a fractional year to a date in Excel? I have tried something like =date(2000 + 1.2, 1, 1) but the result is 1/1/2001 rather than the expected approximate of 3/14/2001.
0
votes
0answers
83 views

Windows 10 - “Sort by Date” but with files on top?

I've noticed that for some reason, anything I unzip uses some other Modified by Date that is far older than when the folder was unzipped on my PC, that makes it very annoying to go through my files. ...
0
votes
0answers
669 views

Creating Multiple Date Ranges in a Pivot Table

While I know its possible for a pivot table to create a date range to showcase values, is it possible to have 3 date ranges? I would like to have 3 columns with date ranges 1. 1/4/19 - 5/25/19 2. 5/26/...
0
votes
1answer
37 views

How to autogenerate a date in a libre calc

I think this is easy but I am not finding solutions online. I have recurring bills and would simply like date values to change every month in their respective cells. For example if cell A2 due date ...
2
votes
1answer
153 views

Calculate Gregorian Julian Date from Regular Date in Excel

I am trying to get a Julian Date from a regular date (mm/dd/yyyy) in Excel. There seems to be two kinds of Julian date calculation. One is described Here.. The other is somehow related to Gregorian ...
0
votes
1answer
111 views

Date math not giving expected result

I've seen several examples (including this post) and it seems simple enough but I don't quite get what I'm doing wrong (I know that post is for linux but I tried w/ the date command on a linux machine ...
0
votes
1answer
44 views

set date +90 days in bash script

I have a bash script to get days from AD since password was created. I need it to tell me the expiration date, which is last set date + 90 days #!/bin/bash pass="$(ldapsearch -Y GSSAPI -Q -H ldap:///...
0
votes
0answers
35 views

How to move Gannt Chart's timeline by changing the week number?

I'm working on a Gannt Chart (Template can be found here) and I was trying to figure out how to move everything that is contained within the timeline by changing the Start Week number. First Figure ...
1
vote
0answers
42 views

Received PDF “scan” of alleged e-mail with Sent time later than Received? Fake?

I recently received a bulk PDF file version of important legal documents / correspondence etc. required for court case. I've found a number of suspicious looking, possibly altered docs, etc. After a ...
1
vote
2answers
178 views

Debian 9 vs Debian 10 different date output, the same locale, the same timezone

Could you please advise what is the reason of this difference? How can I change the output of Debian 10 to display 24 hours format with date command (with no additional parameters). Debian 9 date ...
1
vote
1answer
123 views

GNU/Linux Date Command Ordinal Suffix

The PHP date function offers the ability to add an ordinal suffix for the day of the month, such as 'st', 'nd', 'rd', etc. Is it possible to achieve the same thing with the date command in Linux?
0
votes
0answers
20 views

win7 cannot change date and time: How to fix

I cannot change Windows 7 date and time (not programmatically). A few months ago I used this https://www.thewindowsclub.com/prevent-users-changing-date-time-windows-10 on my Windows 7 computer to ...
1
vote
2answers
43 views

How to convert start/end date to week duration in Excel?

I was wondiring how to convert Start Date and End Date to week duration assuming that the results are always prime numbers? For example:
2
votes
1answer
68 views

Excel default date when dd/mm entered

In Excel when i enter a date into a blank cell (General format) as, say 7/15, the cell changes it's format to "Custom: m-ddd". How can i make doing this default to the standard default date "*3/14/12"...
1
vote
0answers
773 views

Are Excel table headers always converted to text?

I am trying to get table headers containing dates to auto-fill properly, so that they increase by one day between columns. Unfortunately, Excel seems to treat table headers as text regardless of the ...
2
votes
1answer
109 views

I know how to fix Excel dates stored as text, but *why* does it happen?

The question of how to handle dates stored as text in Excel is common, and so are the answers. But can anyone explain why it happens -- and in particular, whose "fault" is it? I use a tool that can ...
1
vote
1answer
674 views

phpmyadmin Default transformations for DateFormat does not change date format

I am using phpmyadmin 4.8.3 running on Ubuntu 16.04.6 LTS with Mysql 14.14 Distrib 5.6.42. I wanted to change the default format yyyy-mm-dd to dd-mm-yyyy. Based on my research I can do this using "...
2
votes
2answers
472 views

No solution for Thunderbird date format

I run Linux Mint 19.2 and Thunderbird 60.8.0 (July 2019). I am trying to change the UI to display the dates in a reasonable date format called ISO 8601, and for that I tried setting LC_TIME=en_DK.UTF-...
0
votes
1answer
215 views

Excel formula to calculate date based on 2 cells and how to copy to other cells?

Novice excel user here. Here is a simplified version of my spreadsheet: start date end date eday duration -21 4 12 0 begindate = "03/...
0
votes
0answers
25 views

Macro is not effective with Date Format Column?

I have written this macro to UNDO any Filters Before saving the spreadsheet. Here is my code: Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) If ActiveSheet.FilterMode ...
0
votes
1answer
80 views

convert Date to Julian day in Excel

How to calculate the fourth column based on the first three columns in Excel? Date cell to Julian day for example: year month day **Julian day** 2000 1 1 1 2000 1 2 ...
0
votes
1answer
50 views

Excel Date calculation

I need to calculate prorated days for real estate closings automatically for the tax prorations. I have everything figured out except I have to manually enter the prorated date. For example, house ...
1
vote
1answer
72 views

Why does time spontaneously change in debian?

Debian 8. Host system, no virtualization. Time synchronization systems are disabled. ntp, rdate, sdwdate are not installed. # timedatectl Local time: Thu 2019-08-22 14:02:05 +03 Universal time: Thu ...
0
votes
0answers
27 views

Adobe Lightroom folders by date in C/Users/Pictures windows 10

tldr: I want to use dated folder structure in C/Users/User/Pictures in Adobe Lightroom, under Windows 10. When I installed Adobe Lightroom 5.6 to Windows 7, it automatically created dated folders in ...
0
votes
0answers
66 views

Keep video creation date when exporting and re-importing from Photos app on macOS

When I Export a video with the Photos app on a Mac, Delete it from the Library, and Re-import it it's always appended to the end of the list, regardless of when it was taken. It seems like the ...
0
votes
1answer
38 views

converting time in excel and/or adding +12 hours

I have this time in excel 2019-08-04T06:48:45.000Z It is in GMT time, how do I convert it to +12 hours? So what I want is 2019-08-04T18:48:45.000Z. That's an easier one(just have to change the hour) ...
1
vote
1answer
21 views

Date formatting only available as root

I have a really weird behavior on both my RaspberryPi 3 and OrangePi 3 after upgrading them to Debian 10. The date command works but I can't set my own formatting with a non-elevated user: baprx@...
0
votes
1answer
28 views

How to convert dates by working backwards from end of month?

I'd like to convert dates to weeks of month, but I'd like the weeks to be counted back to front, kind of. So if there are 5 weeks in a month, I'd like the last 7 days to be week 5, last 8 to 14 days ...
1
vote
1answer
255 views

MS Excel - How to model my data in order to produce a chart broken down into product and month (year on year)?

I have one single date column in my raw data. The dates range across 2018 and 2018. I have multiple products and each row represents a sale transaction. There are multiple transactions per product. ...
0
votes
2answers
59 views

How to manipulate dates?

How can I change a date in an Excel file to eliminate the day and be left with only the month and year?  E.g., convert 4/4/2019 to April-2019? I am aware that I can change the format, but if I do so, ...
1
vote
0answers
23 views

ntp + ntp loose synchronize each time in 5:00 morning

we have a very strange behavior we have 12 Linux redhat machines - redhat 7.x two of these VM servers are loosing the time synchronize each day at 5:00 in the morning after we restart the chronyd , ...
0
votes
1answer
16 views

Debian GNU\Linux Time Differences

i'm trying to find out why my linux have this difference in times: cmd1: date out1: Sun 14 Jul 2019 12:45:59 AM CDT cmd2: hwclock out2: 2019-07-14 00:46:48.389904-04:00 cmd3: timedatectl out3: ...

1
2 3 4 5
9