Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Query Editor / M code for subtracting one day

Hi,   I have the below code in M that gives the number of days between the start date and end date (it works fine): [EndDate]-[StartDate]   But if I try to subtract "1" then I get an error: [En...
  • MarcelBeug's avatar
    8 years ago

    Replace 1 by: #duration(1,0,0,0)