SOLVED

# Status Date

Copper Contributor

# Status Date

I am batteling with the following formula in MS Project: IIf([Status Date]=#2023/01/31#,[Actual Cost],0)

Can somebody please tell my why it keeps on returning 0 even if the Status Date is set as 2023/01/31?

3 Replies
best response confirmed by Dale_HowardMVP (MVP)
Solution

# Re: Status Date

Time part is missing in the date literal #2023/01/31#. Either exclude the times in the comparison expression or add them to both sides. That is, either use Int( [Status Date] ) = #2023/01/31# or [Status Date] = #2023/01/31 17:00# assuming that the status time is 17:00 based on the default end time.

# Re: Status Date

Thanks - problem solved.

# Re: Status Date

You're welcome. And thanks for the feedback.

1 best response

Accepted Solutions
best response confirmed by Dale_HowardMVP (MVP)
Solution

# Re: Status Date

Time part is missing in the date literal #2023/01/31#. Either exclude the times in the comparison expression or add them to both sides. That is, either use Int( [Status Date] ) = #2023/01/31# or [Status Date] = #2023/01/31 17:00# assuming that the status time is 17:00 based on the default end time.