Date/Time dataflow problem

(0) Share

Report

Posted on by SwingeyP

Hi. I have a dataflow that reads time from one column and date from another in a spreadsheet.

No matter how I try I keep getting warnings when I run the dataflow. Can someone tell me what's wrong please?

Reason: Bad Request, Error code: 0x80040239, Message: DateTime is less than minumum value supported by CrmDateTime. Actual value: 01/01/0001 00:00:00, Minimum value supported: 01/01/1753 00:00:00

#"Changed column type 1" = Table.TransformColumnTypes(#"Renamed columns 2", {{"crf79_timeofdelivery", type time}, {"hs_planneddate", type date}, {"hse_dateofdeliveryrescheduled", type date}}),

#"Changed column type 2" = Table.TransformColumnTypes(#"Changed column type 1", {{"crf79_timeofdelivery", type datetime}}),

#"Changed column type with locale" = Table.TransformColumnTypes(#"Changed column type 2", {{"crf79_timeofdelivery", type datetime}}, "en-GB"),

#"Changed column type 3" = Table.TransformColumnTypes(#"Changed column type with locale", {{"crf79_timeofdelivery", type time}})

#"Changed column type 3"

Paul

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

edguerre Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@SwingeyP it appears like you are reading a DateTime value that's lower than the minimum value supported.
Can you post please a picture of the dates from the spreadsheet? One of the values might be incorrectly formatted, for example.

Was this reply helpful? Yes No
SwingeyP 52 on at

Like
a
(0)

Report
Copy link

Link copied!

I have got round it by adding this.

#"Added custom" = Table.AddColumn(#"Renamed columns 2", "NewDate", each Date.ToText([Date of Delivery Attempt], "yyyy/MM/dd"), type date),
  #"Renamed columns 4" = Table.RenameColumns(#"Added custom", {{"NewDate", "hs_PlannedDate"}}),
  #"Added custom 1" = Table.AddColumn(#"Renamed columns 4", "Custom", each Date.ToText([RescheduledDate], "yyyy/MM/dd"), type date),
  #"Renamed columns 5" = Table.RenameColumns(#"Added custom 1", {{"Custom", "hse_dateofdeliveryrescheduled"}}),

Was this reply helpful? Yes No