Forum Discussion
Date Formula
Hi Anonymous ,
First as the error message show, please make sure the data type of both of your two dates columns which are used to compare are date type.
In addition, if you want to use 'AND' condition in the if statement, it should be '&&' instead of '&', '&' is used to combine two columns.
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Championare you able to share what code you have written?
v-yingjlCommunity Support
Hi Anonymous ,
First as the error message show, please make sure the data type of both of your two dates columns which are used to compare are date type.
In addition, if you want to use 'AND' condition in the if statement, it should be '&&' instead of '&', '&' is used to combine two columns.
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.I made those changes and I am just getting blanks now. Is there another way to write this? I feel like crossing tables is ruining this. The Service Crew has been to all of these stores multiple times, but I only want it to return the date if it was in between the Hanging Hardware Call Date and Completion Date.
- v-yingjl
Hi Anonymous ,
Since the columns are come from two different tables, you neeed to create measures by the previous modified formula and use a table visual in the report to show the result instead of creating a calculated column directly.
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.