A man in glasses and a suit jacket points at a glowing blue holographic data display showing charts, numbers, and dates.

In this video, I'm going to go over the community post of calculate correct date. If you'd like to pause the video, I'll I'll let you read through the post. Otherwise, I will start right now. What the user is looking for is they are looking to take a contract start date and a contract length and calculate what is the bill date. Namely, if it is monthly, they are going to bill them 30 days before. For all other frequencies, they'll bill them 90 days before. They also like to calculate the contract end date. So, let's go ahead and do that. First, we will need a formula tool since we'll be doing some calculating. And the first order of business is we need to calculate contract length in months. So we will say contract length in months and we can say if contract length equals annual then 12 LF If it's quarterly, it'll be three. If it's semianually, it will be six. And if it's monthly, it will be one. And if none of those options are selected, it will be null. And then we will end it with an end if. Now when we hit run and we'll convert this to an integer, we can see we have now converted it into a number. Now let's go ahead and calculate contract end date. To do this, we want to add to the start date this number of months. There's a formula called datetime add which takes three arguments. DT will be the start date. I will be how many units are we looking to move and U is the unit in question. So we're going to start it with our start date. I we are looking to move the contract See more