Photo by Annie Spratt on Unsplash I wrote this an article about how to automatically convert Malaysian IC Number to Birthdays five years ago. I was surprised that people recently commented that it didn't support those born after the year 2000. I'm responsible of putting the original information online so I'm obliged to update it if it didn't work. So here I am giving you the updated version. You can play with the excel sheet here to see how it works. The excel formulas that I used above are as below. YYYY-MM-DD Format =CONCATENATE(IF(LEFT(A1,2)<RIGHT(YEAR(TODAY()),2),"20","19"),LEFT(A1,2),"-",MID(A1,3,2),"-",MID(A1,5,2)) DD-MM-YYYY Format =CONCATENATE(MID(A1,5,2),"-",MID(A1,3,2),"-",IF(LEFT(A1,2)<RIGHT(YEAR(TODAY()),2),"20","19"),LEFT(A1,2)) There are two parts to the formula. Depending on the format, the sequence will be different. Generally, I extract the month,
Popular posts from this blog
How to Solve ModuleNotFoundError: No module named 'tencentcloud' on Tencent Serverless Cloud Function?
Introduction You are excited to use Tencent Serverless Cloud Function to do your automation. You are following the Tencent API Explorer and you are ready to rock yet when you test your Python code; you encountered ModuleNotFoundError: No module named 'tencentcloud' . This is a guide on how to solve this error and explanations of why you need to do those steps. How to solve this error According to Tencent Cloud's Serverless Cloud Function's Dependency Installation guide , there are two ways to solve this problem. Package the dependency libraries and code together for upload - I haven't tried this so if you did and it works, please feel free to write a post and comment here. Use dependency management tools. Use dependency management tools to solve this error I'm going to use the same steps as shown in the guide. I will add pictures and edit the steps so that it will be easier for you. Log in to the SCF console and select Function Service on the left sideba
Original photo by Glenn Carstens-Peters on Unsplash Introduction Fundamentals of Digital Marketing by Google Digital Garage is a great resource for anyone who would like to have an overview of digital marketing. Apart from its succinct video content, great quizzes and certification, it also offers links to a wealth of great tools that a digital marketeer needs. However, I can't seem to find a page with an index of this for ease of access and future reference. This is why I have taken upon myself to put this list together. I hope that it will help you as much as it helps me. Links Jargon Busters Digital marketing jargon buster If you are new to the digital marketing world or you've forgotten some of it, here is a list of digital marketing jargons and its meaning. Search engine optimisation jargon buster This is the jargon buster for search engine optimisation aka SEO. Search engine marketing jargon buster This is the jargon buster of search engine marketing aka SEM. W