im trying to make a sword that orbits around the character

Here an example, goal is rotate along the z axis of the character, to get the z axis we get the up vector of the character.

CharacterBP

Graph

You can use a timeline instead of function timer if you want.