Podcast #128: We chat with Kent C Dodds about why he loves React and discuss what life was like in the dark days before Git. Listen now.

Questions tagged [date-and-time]

Questions about Mathematica's date and time functions.

Filter by
Sorted by
Tagged with
1
vote
2answers
108 views

Convert an imported date from excel into a format that mathematica can recognize [closed]

ToString[dates1[[1]]] yields the following: "DateObject[{2006, 10, 5, 0, 0, 0.}, Instant, Gregorian, -5.]" I would like to ...
1
vote
3answers
408 views

Is there a simple way to get the number of milliseconds since the epoch corresponding to a given date?

UnixTime@DateObject@"2017-05-05T01:02:30.5Z" gives the seconds, rounded to an integer, so I can't simply multiply it by 1000 to get the milliseconds. How can I get ...
2
votes
2answers
118 views

Matching DateObject with Cases

OK, here is something that is me missing the obvious. I have an Excel spreadsheet consisting of 2 columns and 5 rows. The first column is formatted in Excel as a dd-mmm-yy date. The second column ...
2
votes
1answer
83 views

Speed of flow of time in Dynamic ClockGauges

Currently trying to utilise the ClockGauge function to display two clocks side-by-side that have different UpdateInterval. The ...
1
vote
3answers
87 views

select, group and manipulate elements in list based on date ranges

Question from a beginner. I have data containing dates and values of the format: ...
2
votes
1answer
110 views

TimeLinePlot: change the y-axes ranges

I want to combine a TimeLinePlot with a DateListPlot. My questions are: Can you change the Y-axes of a ...
1
vote
1answer
145 views

Import and DatelistPlot from CSV

I have daily time series data on a CSV that I'm trying to plot, but I can't seem to make it work nor can I find a clear answer as to what I'm doing wrong. This is ...
2
votes
0answers
30 views

AbsoluteTiming gives vastly smaller results than it should

I've been having some recurrent issues with AbsoluteTiming and I would like to have a better idea of what causes them and whether they can be avoided. More ...
0
votes
0answers
64 views

Why does Interpreter fail intermittently?

I notice that, when I process CSV files and using Interpreter, I sometimes get Interpreter failure for certain dates as shown below: I am using the following ...
3
votes
1answer
102 views

What is the syntax for `EntityProperty` `“Date”` and `“DateRange”` Qualifiers?

Does anyone know how to get EntityProperty "Date" and "DateRange" qualifiers to return data? ...
2
votes
0answers
145 views

Broken DateListPlot in Mathematica 11.2 [closed]

Fresh kernel, Mathematica 11.2, MacOS. Ticks are not shown when using DateListPlot. "Dynamic Updating Enabled" option does not ...
5
votes
0answers
51 views

Speeding up Gather / DatePlus combination

I am working on a project that involves identifying runs of dates that fall within five business days of each other. Given a list of dates in inDates, the following ...
5
votes
1answer
213 views

Business Days between two dates

I can easily add business days to a given date, future = DatePlus[Today, {9, "BusinessDay"}] Is there some way to measure the business days between two dates? In ...
1
vote
0answers
92 views

Inequalities with DateObjects

Here the simplest example of this kind of bug ...
4
votes
1answer
397 views

Change x-axis date range in DateListPlot

unfortunately, I have a simple problem with my DateListPlot which I cannot solve on my own (with the guidance online). The code looks as follows: ...
0
votes
0answers
42 views

Problem in using FrameTicks option in DateListPlot command

everyone. I have prepared a code in which a file of data to be called and its data will be used to make a plot. I wanted to divide the x axis, as I needed but the output is not what I need. I want to ...
2
votes
4answers
109 views

How can I strip the time from the result of applying DatePlus?

DatePlus["12 May 2017",2] gives "Sun 14 May 2017 00:00:00" How can I get just the ...
3
votes
1answer
174 views

Combine TimelinePlot and DateListPlot

I want to combine a TimeLinePlot and a DataListPlot. For both I use the same periode. The problem is that both X-axis differ ...
1
vote
3answers
135 views

NA handling in TimeSeries[“Date”] … “0. + NA”

I import data from excel in the following format: data // MatrixForm After converting the data to a time series, the "NA" values are converted to "0. + NA", when ...
1
vote
2answers
54 views

How to round data to the nearest Quarter?

I deleted my previous post since I believe it had unnecessary information and the direction of the question seemed to be straying away from what I wanted. I apologize to anyone that looked into it. ...
1
vote
1answer
101 views

How to count frequency of numbers while accounting for the time of the data?

I am hoping to get some guidance as to how to tackle this problem. I have the following sample dataset with the dates in YYYYMMDD format: ...
2
votes
2answers
62 views

Trying to plot two time series from data in external file

I am a newbie into Mathematica and taking a steep learning curve. I have been struggling with this for a couple of days now. Can someone point me in the right direction? I have time-stamped ...
4
votes
1answer
284 views

DateListPlot of multiple time series with data values and legend appearing as the cursor moves over ploted lines

This is very similar to my previous question. I want to use "DateListPlot" to visualize multiple time series (n) and see data values and legend as I move the cursor ...
0
votes
0answers
29 views

How to format time durations for media clips {audio, video, music, science etc}

Mathematica has powerful date, time and timeseries functions and options. Yet they all seem to be tightly tied to Time in global clock-calendar-astronomic perception. I need to do basic time-duration ...
5
votes
2answers
705 views

How do I plot multiple time series from a Dataset?

I have a Dataset ds with a straightforward tabular structure containing one column Date ...
1
vote
1answer
144 views

replace missing values in table with timeseries

I've got my data from a SQL-query like: Select[date0 /. SQLDateTime -> DateObject, #[[1]] > DateObject[{2016, 1, 1, 0, 0, 0.`}] &]; A ...
1
vote
2answers
111 views

TimelinePlot y-axis Misaligned

When plotting an Association of data in TimelinePlot the y-axis is labeled with the Keys. ...
0
votes
0answers
72 views

Control interpretation by Import

When I Import an Excel file, sometimes Mathematica interprets the dates as DateObjects, and sometimes it doesn't. How can I ...
6
votes
3answers
212 views

Inconsistent DateObjects in Range stepped by Month

A number of inconsistencies using Range with DateObject when they are stepped through using (time) ...
3
votes
2answers
110 views

How to merger every three minutes values?

I have some date values like date=Uncompress[FromCharacterCode[ Flatten[ImageData[Import["http://i.stack.imgur.com/QLINL.png"],"Byte"]]]] ...
4
votes
1answer
66 views

Getting time zones by answer times

So I built an SE service connection and as a piece of pure curiosity I wanted to see if I could determine what a given user's time-zone was by the times which they answer. I managed to pull in all ...
4
votes
1answer
206 views

How to use Callout in TimelinePlot?

I'd like to annotate a datapoint in my TimelinePlot with a callout. Is there a way or a hack that anyone knows of to get this to work? ...
11
votes
2answers
198 views

How do you import “ISODateTime” and capture the time zone?

Bug introduced in V10.4 or earlier and persisting through 11.3 (CASE:3920785) Back in version 10.2 or so, Mathematica began supporting the ISO 8601 date/time format, which is nice because it's used ...
3
votes
1answer
73 views

Elegant way to return first non-Missing column in Dataset

I have a Dataset[] with some data and a TON of columns. Each row contains several columns for dates, which contain DateObject ...
0
votes
0answers
57 views

How do i plot a histogram from grouped data rather than raw [duplicate]

I have a data which is grouped in the following format: {{date1,count1},{date2,count2},...} I want to make a Date Histogram of this data. Apparently the ...
3
votes
1answer
51 views

Why does the TimeObject seem to lose precision? (+ note on units)

According to the documentation (11.0.1.0) Shorter lists can be used in TimeObject[{h,m,s}], which represents the time to whatever accuracy is specified: {h} is not [sic?*] treated as being ...
2
votes
1answer
128 views

Add another holiday to the built-in holiday calendar

Mathematica offers holiday calendars, which is GREAT! Especially because adding a days to a date with DatePlus[{2015,4,2},{1,"BusinessDay"}] can skip straight to ...
3
votes
1answer
194 views

How can I plot with DateListPlot data for the same month but different Year?

I have the following. dataMarch2016 =incomeByDay[Select[ DateValue[#Date, {"Year", "Month"}] == {2016, 3} &]] And the following. ...
1
vote
0answers
19 views

Dates and LessEqual (<=) [duplicate]

The following does not return anything (Mathematica 11). I was expecting that "true" would be printed. ...
1
vote
0answers
28 views

DateString doesn't evaluate within Dataset [duplicate]

[11.1] Starting with a DateObject in a Dataset: data = Dataset[<|"a" -> Now|>] ...
0
votes
1answer
114 views

Doing Date Comparisons w/ {yr, mo, day} Dates

I'm working with dates in the form, e.g., t1 = {2017,4,17} and t2 = {2017,4,3}. I want to execute commands like ...
5
votes
1answer
105 views

DayName giving incorrect days with TimeZoneConvert

So I used TimeZoneConvert to get the time in GMT: TimeZoneConvert[Now,"GMT"] It outputs a date object that says ...
1
vote
1answer
82 views

How to interpret DateListPlot FrameTicks in Mathematica 11

In Mathematica 7 frame ticks from a DateListPlot were amenable to editing. How can I obtain this information from DateListPlot ...
0
votes
2answers
75 views

How to visualize a series of TimeObject? [closed]

data = Get["http://home.ustc.edu.cn/~xiaozh/SE/data.wl"]; And data can access data["a"],<...
4
votes
1answer
178 views

How to download Entity data for an interval of dates

I am interested in downloading "TropicalStorm" data for hurricanes with the highest "WindSpeed" occurring in the years 1990 ...
10
votes
3answers
403 views

How to work with Date calculations?

I have never worked using the DateObject function But I suspect there must be a (easy) way of doing it. I want to find out, when in the future, from which point, ...
1
vote
1answer
73 views

Is there a way to improve the performance of this code in order to reduce the time needed?

I'm working with binary protein interactions, and with the data that I have I use Mathematica to generate a Graph with all the interactions. Since most of the organisms have thousands of proteins and ...
1
vote
0answers
36 views

Inconsistent display of DateObjects in Dataset [closed]

This question is similar issue to here. <|"a" -> DateObject[{2014, 1, 14}], "b" -> {DateObject[{2015, 3, 23}], DateObject[{2015, 3, 30}]}|> // Dataset The formatting is the same if the ...
0
votes
0answers
32 views

Unexpected results from TimeSeries + Accumulate [duplicate]

I want to have calculate a cummulative series from the existing one. In a simplified example, let's say there's a series: ...
6
votes
2answers
106 views

Use SemanticImport on column with UnixTime in miliseconds

When I use SemanticImport on a csv file with the following data I get a DateObject with the year value in the 40 thousands, e.g. ...