What does the following formula return? AdjustMonth(ToDate("2/20/99"), 2)

Prepare for the Quickbase Certification Exam with interactive quizzes and comprehensive resources. Enhance your skills and get exam-ready with targeted practice questions and detailed explanations.

The formula utilizes the function ToDate("2/20/99") to convert the string "2/20/99" into a date format. This date corresponds to February 20, 1999.

The function AdjustMonth then takes this date and adds two months to it. When you add two months to February, you move into April. Therefore, adding two months to February 20, 1999 results in April 20, 1999.

Thus, the final output of the formula is correctly represented as 20-Apr-99. This explains why the correct answer is the date of April 20, 1999.

Subscribe

Get the latest from Examzify

You can unsubscribe at any time. Read our privacy policy