Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
can anyone tell how i can join two outputs.
example year(today()) gives me 2017 and week(today()) gives me 48. i want output to be 201748
Thanks In advance
year(today())&Num(week(today()),'00')
year(today())&Num(week(today()),'00')
If you need a numeric output you need a calculation instead of a string-concat, maybe like:
year(today()) * 100 + week(today())
- Marcus