To check whether the Date created date and Line system note date is the same or not

If you want to check whether the sales order’s date created and the line system notes date are the same or not, we need to create a formula text field in the saved search.

formulatext: CASE WHEN (TO_CHAR({datecreated}, 'DD/MM/YYYY HH24:MI')=TO_CHAR({linesystemnotes.date}, 'DD/MM/YYYY HH24:MI')) THEN 'Yes' ELSE 'No' END

When we use this formula in the saved search result, then it will shows the 'Yes' if both the dates, hour, minutes are same.

Leave a comment

Your email address will not be published. Required fields are marked *