How do I add - YYYY WK - 2023 20 format on QS

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