How do I add - YYYY WK - 2023 20 format on QS, through QS calculative fields
you can try
concat(
extract('YYYY', mydate),
' ',
toString(dateDiff(truncDate('YYYY', mydate), mydate, 'WK'))
)
1 Like