Forum Discussion
Atinder
Helper III
Helper IIIAdd IF date formula in the custom date
Hello, I want to add a custom date column in the table by using IF function. I want to see what items I received today by the posting date. = Table.AddColumn(#"Expanded PostedPO", "Custom...
My bad, I used the wrong syntax.
How about this:
= Table.AddColumn(#"Changed Type", "Custom", each if [PostedPO.Posting_Date] >= Date.AddDays(Date.From(DateTime.LocalNow()), - 1) then "yes" else null)
/Tom
tackytechtom
Most Valuable Professional
Most Valuable ProfessionalHi @Atinder ,
Does it work that way?
Table.AddColumn(#"Expanded PostedPO", "Custom", each if [PostedPO.Posting_Date] >= Date.AddDays(DateTime.LocalNow(),-1)) then "yes" else null)
Let me know!
/Tom
- KNP
Super User
In the 'Custom Column' box you just need to enter this part...
if [PostedPO.Posting_Date] >= Date.AddDays(DateTime.LocalNow(),-1)) then "yes" else nullNot from the "Table.AddColumn...."
If this works, please accept Tom's answer as the solution, not this one.
AtinderI am also getting this error
- KNP
Apologies, I copied the wrong text from tackytechtom's answer. Use the below instead.
Again, please accept Tom's answer if this solves your problem.
if [PostedPO.Posting_Date] >= Date.AddDays(Date.From(DateTime.LocalNow()), - 1) then "yes" else null
- tackytechtom
My bad, I used the wrong syntax.
How about this:
= Table.AddColumn(#"Changed Type", "Custom", each if [PostedPO.Posting_Date] >= Date.AddDays(Date.From(DateTime.LocalNow()), - 1) then "yes" else null)
/Tom
