Neil Scrivener Posted April 2, 2016 Share Posted April 2, 2016 Hi Guys, I have the following fields: 1) Invoice Date (which gets the day the data is entered) 2) Term (which is a number of days from the above date the invoice is due). 3) Due Date. I'm struggling slight on the Due Date. I've made the field a Calculation. My Calculation is (Invoice Date) +Term. So, for example with a 30 day term, and the date as 02/04/2016 my calculated result is 736086 (it should be 30 days from 2nd April).......hmmm not quite the date I was hoping for! I've tried Data Formatting, but can't get the date up. Clearly I''m doing something wrong, and I'm sure it's blindingly obvious? Cheers N Link to comment Share on other sites More sharing options...
Lee Smith Posted April 2, 2016 Share Posted April 2, 2016 Change the result from Number to Date (Options) for the Calculation. Link to comment Share on other sites More sharing options...
Neil Scrivener Posted April 2, 2016 Author Share Posted April 2, 2016 Bingo, thanks lee Seems I need to get better at checking all the boxes and all the options! Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 3108 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now