Precautions for specifying the year of the date format when using date function

 
Regarding the format when using date function, if you use an uppercase "Y" to specify the year, it will be specified as the "base year of the calendar week" instead of the year in the A.D.

 * The same format as Java's SimpleDateFormat is used.

Therefore, when specifying the year, use the lowercase "y" instead of the uppercase "Y".

 * When "YYYY" is used to specify the year
  The first week of 2022, the base year of the calendar week, will be from 2021/12/26 to 2022/01/01. Year 2022 is also acquired between December 26th and 31st, 2021.
  If you want to use the year in the A.D., please specify "yyyy" using "y" in lowercase.

For reference, please refer to the following for the format.

IM-FormaDesigner for Accel Platform IM-FormaDesigner Designer Help
Date function
https://document.intra-mart.jp/library/forma/public/forma_designer_help/item_help/common/common_explanation/special/function_list/function_date.html

-- Target ----------------------------------------------------------------------
iAP/Accel Extensions/IM-FormaDesigner for Accel Platform/All Updates
--------------------------------------------------------------------------------

FAQID:1158
Was this article helpful?
0 out of 0 found this helpful
Powered by Zendesk