What is the correct formula to subtract a number of days from the transaction date for a custom field, not search? For some reason I can't get even get {trandate} to source in on it's own. The field is set to free-form text. It brings in {today} just fine.

for some reason i've had to start using the TO_CHAR() function everytime i work with dates in searches. Never had to before.... Anyway, TO_CHAR({trandate}-1) works for me. 1 being the amount of days to subtract

@Cory Weiner Thanks for your response! I think that works for searches but for some reason custom fields aren't taking {trandate}