This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Sorry about that. I made an error when typing it in. Plus I think I had a lot of unnecessary logic in there. This is my formula simplified.
IF [ProjectStatus]="Re Hold" THEN "RE HOLD" ELSEIF [Construction_Start]>DateTimeToday() THEN "NS" ELSEIF [Construction_Start]<DateTimeToday() && [Store_Open]>DateTimeToday() THEN "CIP" ELSEIF [Store_Open]<DateTimeToday() THEN "OPEN" ELSE "" ENDIF
I work in the Real Estate department for a Retailer. What I want to happen is, on the day I run the report, if a Construction Start Date is in the future and therefore hasn't happened yet, then I want it to return a status of "NS" (Not Started). If the Construction Start Date is in the past, but the Store Open Date is in the future and yet to occur, then I want it to return a status of "CIP" (Construction in Progress). Lastly If the Store Open Date is in the past then I want it to return a status of "Open". The first part, "RE HOLD" is just looking for if a project is currently on hold and therefore we are not concerned about where it is at in the construction process.
Everything seems good in your new expression, see attached for an example. What is the data type of your date fields, are they Date data type? You can check this with a Select tool.
If they are date data type, and it is still not giving you the result you are looking for, can you attach a workflow with sample data, along with what results are incorrect and what you expect them to be? Thank you!
Oh ok, I misunderstood the parse tool. So to parse you are stating the format the date is in now? I changed that and that worked. Now after my calculation am I then safe to change the format to %m-%d-%y using DateTimeFormat?