Hiya
and thanks to all yesterday that put me on the right track with the \ in the year field
Hopefully this will resolve all my YEAR issues,
How can I please change 2021-10-01 (eg) to show just 2021
Thanks in advance
Steve
Hiya
and thanks to all yesterday that put me on the right track with the \ in the year field
Hopefully this will resolve all my YEAR issues,
How can I please change 2021-10-01 (eg) to show just 2021
Thanks in advance
Steve
Try an action of the type "FOrmat value" for YEAR
Format string: $num(%year%,1)
thank you so much works a treat