Search the Community
Showing results for tags 'formula field'.
I have a formula field which calculates a number value perfectly but I'd like to add a letter to the front of the number so I assume that means I need to cast my result to a string. Here is my formula right now: SELECT MAX(Clean_Job) FROM tbl_ggl_job WHERE Job_Letter = 'CC') + 1 Which gets the max job number that is currently in use and adds 1 to that. So if the max job is CC100 this would return 101. I'd like to concatenate this with the Job Letter CC so that the result would look like CC101. How can I do this?
Hello - I have and Start_Date field with Data type Date/Time. I added another field that is call Renewal_date with Formula field data type. May I please ask for the formula to use in my Renewal_date field. For example: Start_Date - 07/15/2017 Expected Renewal Date should be = 07/15/2018