When you want to apply a minor tweak to the document, it should not take long to Collate date log. This kind of basic action does not have to demand extra training or running through handbooks to understand it. With the appropriate document editing tool, you will not take more time than is necessary for such a quick change. Use DocHub to streamline your editing process regardless if you are a skilled user or if it’s your first time making use of an online editor service. This instrument will take minutes to learn how to Collate date log. The only thing required to get more effective with editing is actually a DocHub account.
A plain document editor like DocHub will help you optimize the time you need to devote to document editing irrespective of your prior knowledge about such tools. Create an account now and increase your efficiency instantly with DocHub!
at times you want to convert date or time into text so that their format doesnt change or you may want to concatenate to both of them together so how will you do that so its pretty easy but not very obvious because in case you are just using concatenate function it wont function so lets see if we are choosing a1 and b1 and were trying to concatenate them it wont work because they are in different formats this one is in date format while this one is in time format so this wont work this wont concatenate so you have to do something else which is to convert them into text so its pretty easy we are using concatenate but we are using text as the function so we are selecting the value to which we have to convert into text so this is currently in the date format but we will be converting that into text format no inverted comma starts and what would be the format of the values so in this case we have DD because date mm is month and then here is this we can just close the inverted com