Here is a link to the date and time functions you can use in VA (around page 155). I'm a bit rusty with these so probably best you check them out for yourself.
Catch up on SAS Innovate 2026
Nearly 200 sessions are now available on demand with the SAS Innovate Digital Pass.