Adding days to a date field & return only date portion
I'm trying to create a Payment Due Date field by adding X days to the Invoice Date field.
I would like to return only the DATE portion without the time. How should I write my formula?
My formula: Adddate(${Invoices.Invoice Date},30,'DAY')
My result is:
17/05/2012 12:00 AM
Thanks!