Group Abstract

Message Boards

WOLFRAM COMMUNITY

2.8K Views

8 Replies

2 Total Likes

View groups...

Follow this post

Share this post:

GROUPS:

Wolfram Language Units

Date String "20240811222725" cannot be interpreted as a date?

Steven Buehler

Posted 11 months ago

Instruction: FromDateString["20240811222725", {"Year", "Month", "Day", "Hour", "Minute", "Second"},TimeZone->"UTC"] Result: FromDateString: String 20240811222725 cannot be interpreted as a date in the specified format. What am I doing wrong?

POSTED BY: Steven Buehler

8 Replies

Sort By:

Mariusz Iwaniuk

Mariusz Iwaniuk, engineer, math hobbyist.

Posted 11 months ago

the code can by simplified more: DateObject[ToExpression@StringTake["20240811222725", Join[{{1, 4}}, Partition[Range[5, 14], 2]]]] Regards M.I.

POSTED BY: Mariusz Iwaniuk

Sascha Kratky

Sascha Kratky, uni software plus GmbH

Posted 11 months ago

Try setting the delimiters explicitly, i.e.: FromDateString["20240811222725", <\| "Elements" -> {"Year", "Month", "Day", "Hour", "Minute", "Second"}, "Delimiters" -> {""}\|>, TimeZone -> "UTC"]

POSTED BY: Sascha Kratky

Steven Buehler

Posted 11 months ago

Or, quicker: ExternalEvaluate["Python","import datetime; datetime.datetime.strptime('20220811123456","%Y%m%d%H%M%S")"]

POSTED BY: Steven Buehler

Steven Buehler

Posted 11 months ago

Quicker (or, rather, easier for this amateur) to use an `ExternalEvaluate` of `strptime()` in Python than trying to split the string all up in Wolfram. :-)

POSTED BY: Steven Buehler

Mariusz Iwaniuk

Mariusz Iwaniuk, engineer, math hobbyist.

Posted 11 months ago

FromDateString command dosen't take your format date. In Mathematica: DATE = "20240811222725"; DateObject[{StringTake[DATE, {1, 4}] // ToExpression, StringTake[DATE, {5, 6}] // ToExpression, StringTake[DATE, {7, 8}] // ToExpression, StringTake[DATE, {9, 10}] // ToExpression, StringTake[DATE, {11, 12}] // ToExpression, StringTake[DATE, {13, 14}] // ToExpression}] (Gives date)

FromDateString command dosen't take your format date.

In Mathematica:

DATE = "20240811222725";

DateObject[{StringTake[DATE, {1, 4}] // ToExpression, 
  StringTake[DATE, {5, 6}] // ToExpression, 
  StringTake[DATE, {7, 8}] // ToExpression, 
  StringTake[DATE, {9, 10}] // ToExpression, 
  StringTake[DATE, {11, 12}] // ToExpression, 
  StringTake[DATE, {13, 14}] // ToExpression}]
 (*Gives date*)

POSTED BY: Mariusz Iwaniuk