Exercise

Formatting dates with FORMAT()

The FORMAT() function allows for additional flexibility in building dates. It takes in three parameters: the input value, the input format, and an optional culture (such as en-US for US English or zh-cn for Simplified Chinese).

In the following exercises, we will investigate three separate methods for formatting dates using the FORMAT() function against the day that Python 3 became generally available: December 3rd, 2008.

Instructions 1/3

XP

1
2
3

Fill in the function and use the 'd' format parameter to format as short dates. Also, fill in the culture for Japan, which in the .NET framework is jp-JP.

Take Hint (-10 XP)