Forum Discussion

IF's avatar
IF
Icon for Post Prodigy rankPost Prodigy
2 years ago

Automatic date input

Hi, I get the data from SAP with the following format: let Source = SapBusinessWarehouse.Cubes(................), #"Added Items" = .......... { {Cube.ApplyParameter, "[!V000003]", {#date(2023, 9...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

What is the expected date format in SAP?  try this:

 

{Date.From(DateTime.LocalNow()), Date.From(DateTime.LocalNow()+#duration(1,0,0,0))}

  • IF's avatar
    IF
    Icon for Post Prodigy rankPost Prodigy
    2 years ago

    Hi,

    The format that i see when i put the values is: { {Cube.ApplyParameter, "[!V000003]", {#date(2023, 9, 20), #date(2023, 9, 21)}},

     

    in this format. i don't know it helps. I could not try the query yet.

     

    Thanks a lot

  • IF's avatar
    IF
    Icon for Post Prodigy rankPost Prodigy
    2 years ago

    there are two different formats that i am struggling with:

    1. { {Cube.ApplyParameter, "[!V000003]", {#date(2023, 9, 20), #date(2023, 9, 21)}},

      in this case i should be enter the parameter as "2023,9,20"

     

    2.  {Cube.ApplyParameter, "[0I_DN]", {"[GLP].[20231002]", "[GLP].[20231002]"}},

     in this case i should enter the value as "20231002"

     

    I tried this:

    Today = DateTime.Date(DateTime.LocalNow()),
    Yesterday = Date.AddDays(Today, -1),

    {Cube.ApplyParameter, "[0I_DAYIN]", {"[Y4FGLTRP].Yesterday", "[Y4FGLTRP].Today"}},

     

    but it didn't work. i need to provide the input in the same way as i provided in the example.