How do I use ‘~’ (tilde) in the context of paths?

it is your $HOME var in UNIX, which usually is /home/username.

“Your home” meaning the home of the user who’s executing a command like cd ~/MyDocuments/ is cd /home/user_executing_cd_commnd/MyDocuments