Anyone have thoughts on my post from yesterday? I ...
# advancedpdfr
reptar
05/25/2023, 7:07 PMAnyone have thoughts on my post from yesterday? I have confirmed both in the UI and in field explorer that the field's date is 2024, but it's printing as 2025.
watching following 2
a
alien4u
05/25/2023, 7:35 PMDid you tried removing the formatting? string["MMM dd YYYY"]?
c
creece
05/25/2023, 7:58 PMabsolute worst case you can create a custom field w/ the format you want and put the value in there and grab it.
Have you tried
${record.enddate?date}
or
${record.enddate?date?string["MMM dd YYYY"}
e
ericbirdsall
05/25/2023, 8:16 PMIs the year +1 happening on all records of that type? or just that specific date?
r
reptar
05/26/2023, 7:16 PMOnly reported for one invoice so far
reptar
05/26/2023, 7:21 PMRemoving the string formatting fixes it, but that's not acceptable. Adding date does not.
a
alien4u
05/26/2023, 8:04 PM@reptar Try with:
${record.enddate?string["MMM dd *yyyy*"]}
Notice the lowercase yyyy.
r
reptar
05/26/2023, 9:21 PMResolved? lol
reptar
05/26/2023, 9:22 PMThat made it 2024
a
alien4u
05/26/2023, 9:22 PMYYYY in upper case means weak year which only differs from year(yyyy) at the last few weeks…
r
reptar
05/26/2023, 9:25 PMDoc? I'm currently here: https://freemarker.apache.org/docs/ref_builtins_date.html#ref_builtin_string_for_date
a
alien4u
05/26/2023, 9:27 PMYou are almost there, see the warning here:
https://freemarker.apache.org/docs/ref_directive_setting.html#topic.dateTimeFormatSettings
✅ 1