Hello Li - change that Countd() to just return the field [Job Code] when that condition is true.
I would change this to be something like this example:
if datepart('year',[new order date])=datepart('year',today()) and datepart('month',[new order date])=datepart('month',today()) then [Customer ID] End
and then run your countd on the new created field.
see attached workbook example.
Maybe others will chime in with their own best ideas of how to do.. Rody Zakovich maybe?
Thank you very much for your reply!!!
I am only new to this forum and somehow I couldn't find your attachment.
Thank you very much! this solved my puzzle!! It worked!!!
Another trick added onto my list of things to try when stuck. But what is the logic behind it? Why is that we had to separate the formula into two parts?
PS: not sure what happened, I couldn’t log in at all using Microsoft Edge; I couldn’t reply message using google chrome; I couldn’t see online attachment using IE