Hi all, I am new to TextBlaze & am having trouble with a specific section of code which is my final step until the snip is fully operational! For reference I am working off a MS Teams spreadsheet whereby I copy a transaction date, and need to offset this by -3 weeks within a calendar field. I can work out the offset itself but this only defaults from current/system date whereas the date on my clipboard can vary from 4 weeks to 12 weeks in future.
Ie. today is 18/07/2022 & the transaction date is 04/10/2022 (clipboard), I need to somehow lock the start date to clipboard then -3 weeks offset