Internally, Panorama stores dates as an integer number. But when a date is displayed or printed, it is converted to text so that you can read it. This conversion can take different forms, for example the date July 20, 1969 could be formatted many ways, some of which are shown here:
7/20/69 07/20/69 20-Jul-69 July 20th, 1969
By default, Panorama will pick the simplest format, but you can explicitly control how dates are formatted by using a Date Pattern. See Date Patterns to learn all the details.
Panorama is very flexible about how you type dates. We call this feature smart dates. You can enter dates numerically (for instance
4/9/2) or you can spell out the date (for instance
April 9th, 1997 or
Apr 9 97). You can use any character as a separator between numeric dates, for example
4-9-01 or even
To enter today’s date, simply type
today. You can also enter
tomorrow. Panorama will automatically convert these entries to the correct month, day and year.
If the date is in the current week, you can simply type in the name of the day, for example
tue. To specify a day in the previous or upcoming weeks add the words last or next, for example
next tuesday or
When you enter a date, you can leave the year off and let Panorama figure it out for you. Panorama will automatically round the date to the nearest year. For instance, if today’s date is 1/11/17 and you enter the date 4/1 then Panorama will assume you mean 4/1/17. But if you enter 12/12 (or December 12) Panorama will assume you mean 12/12/16, not 12/12/17, because 12/12/16 is closer to 1/11/17 than 12/12/17 is.
Panorama also rounds dates to the current century. If the current year is 2002 (or even 1992) and you enter the date
7/2/23 Panorama will assume you mean 7/2/2023. If you want to enter a date more than 50 years from the current date you must enter the full date, for example
|10.0||No Change||Carried over from Panorama 6.0|