Getting a specific date from today()

General Tech Bugs & Fixes 2 years ago

0 1 0 0 0 tuteeHUB earn credit +10 pts

5 Star Rating 1 Rating

Posted on 16 Aug 2022, this text provides information on Bugs & Fixes related to General Tech. Please note that while accuracy is prioritized, the data presented might not be entirely correct or up-to-date. This information is offered for general knowledge and informational purposes only, and should not be considered as a substitute for professional advice.

Take Quiz To Earn Credits!

Turn Your Knowledge into Earnings.

tuteehub_quiz

Answers (1)

Post Answer
profilepic.png
manpreet Tuteehub forum best answer Best Answer 2 years ago

I currently have use the following code to give me the date of today as yyyymm.

Today = FORMAT(TODAY(), "yyyymm")

The problem is that I need to get the same format yyyymm for 6 months from now

So if today is 201903, I need 201909.

I have been able to return the month, 6 months from now with:

6MonthsFromNow = MONTH(TODAY()) + 6

But that doesn't really help me as I need the year and month as yyyymm

0 views
0 shares

No matter what stage you're at in your education or career, TuteeHub will help you reach the next level that you're aiming for. Simply,Choose a subject/topic and get started in self-paced practice sessions to improve your knowledge and scores.