Add IF date formula in the custom date

[Atinder]

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", each if [PostedPO.Posting_Date] >= #date(today()) then "yes" else null)

[tackytechtom]

Hi @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

https://www.tackytech.blog

https://www.instagram.com/tackytechtom

[Atinder]

Hi@Tom,

No, I am getting this error.

[KNP]

In the 'Custom Column' box you just need to enter this part...

if [PostedPO.Posting_Date] >= Date.AddDays(DateTime.LocalNow(),-1)) then "yes" else null

Not from the "Table.AddColumn...."

If this works, please accept Tom's answer as the solution, not this one.

[Atinder]

I 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

[Atinder]

hi@KNP

i am getting this error.

[tackytechtom · Accepted solution]

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

https://www.tackytech.blog

https://www.instagram.com/tackytechtom

[tackytechtom]

Hi @Atinder ,

how about this:

Date.AddDays(DateTime.LocalNow(),-1)

/Tom

https://www.tackytech.blog

https://www.instagram.com/tackytechtom

[Atinder]

Hi@Tom,

I am getting error but this message pops up when I put -1. 

[tackytechtom]

Hi @Atinder ,

This code snippet might help you:

Table.AddColumn(#"Expanded PostedPO", "Custom", each if [PostedPO.Posting_Date] >= Date.From(DateTime.LocalNow()) then "yes" else null)

Let me know!

/Tom

https://www.tackytech.blog

https://www.instagram.com/tackytechtom

[Atinder]

Hi@Tom,

Solution works. How can I look yesterday's posting date. I tried to put -1 after now()-1 but it is not working.