Forum Discussion
Solved
Adding Days to current date
So i have a field that shows the number of days till out of inventory and I want to have it add to the current date so I know what the date is the inventory will run out. Then I can compare the date...
You could add a column. Say your last step name is FinalStep, and your days on hand field is DaysOnHand:
CurrentDate= Date.From(DateTime.LocalNow()),
NewColumn = Table.AddColumn(FinalStep, "OutOfStockDate", each Date.AddDays(CurrentDate, [DaysOnHand]))This will add the amount of days from DaysOnHand to today's date.
--Nate
You could add a column. Say your last step name is FinalStep, and your days on hand field is DaysOnHand:
CurrentDate= Date.From(DateTime.LocalNow()),
NewColumn = Table.AddColumn(FinalStep, "OutOfStockDate", each Date.AddDays(CurrentDate, [DaysOnHand]))
This will add the amount of days from DaysOnHand to today's date.
--Nate