Forum Discussion

mb0307's avatar
mb0307
Responsive Resident
5 years ago
Solved

DataSource.Error - enter value in a permitted format'

Hi,   START DATE query below is being used as parameter to filter the data extracted from SAP BW.   let Today = Date.From(DateTime.FixedLocalNow()), Minus6MonthsFirstDayOfMonth = Date.S...
Need Help
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    I'm guessing it is related to the day going to two digits (10) and your step where it adds "0" to it.  Your last step should address that, but here is a simpler way to get to your desired format with Date.ToText.

     

    let

    Minus6MonthsFirstDayOfMonth = Date.StartOfMonth(Date.AddMonths(Date.From(DateTime.FixedLocalNow()),-6)),
    Custom1 = Date.ToText(Minus6MonthsFirstDayOfMonth, "MM/dd/yyyy")
    in
    Custom1

     

    Pat

mahoneypat's avatar
mahoneypat
Microsoft Employee
5 years ago

I'm guessing it is related to the day going to two digits (10) and your step where it adds "0" to it.  Your last step should address that, but here is a simpler way to get to your desired format with Date.ToText.

 

let

Minus6MonthsFirstDayOfMonth = Date.StartOfMonth(Date.AddMonths(Date.From(DateTime.FixedLocalNow()),-6)),
Custom1 = Date.ToText(Minus6MonthsFirstDayOfMonth, "MM/dd/yyyy")
in
Custom1

 

Pat

mb0307's avatar
mb0307
Responsive Resident
5 years ago

mahoneypat  Thanks that worked.