enter image description here

 TScci30clean = TimeSeries[cci30clean[[2 ;;]]]

I dont understand why this shows an error ,i have changed the date format twice in excel sheet that im working on and still shows this error.

  • $\begingroup$ First, it's a warning, not an error. Did you check whether the result matches what you want? Second, the message seems pretty clear to me. Somewhere in your computation the expression AbsoluteTime["11-12-2020"] is evaluated, and since that would be interpreted differently by different conventions, it's ambiguous. To give more guidance, we'd need to see more of your code--a minimal amount to let us reproduce the warning. Might also need to see the format of the data you're importing. $\endgroup$
    – lericr
    Jul 6, 2022 at 14:16
  • $\begingroup$ I actually formatted the data from excel after this.Thanks $\endgroup$ Jul 19, 2022 at 23:28

1 Answer 1


A date string such as 11-12-2020 may be interpreted as meaning 11 December or 12 November. AbsoluteTime will provide a default with a warning about the ambiguity. The actual order can be specified in AbsoluteTime.

(* 3 814 128 000 with a warning *)
AbsoluteTime[{"11-12-2020", {"Month", "Day", "Year"}}]
(* 3 814 128 000 *)
AbsoluteTime[{"11-12-2020", {"Day", "Month", "Year"}}] 
(* 3 816 633 600 *)
  • $\begingroup$ Thanks for that $\endgroup$ Jul 19, 2022 at 23:29

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.