Set a variable combining text and current date
I want to set a variable that takes the form of "YYYY-MM - text string".
I want to use this variable to set the value of a field in a group of newly created records.
For the LIFE of me (!), I have not been able to do this using multiple variations of the Let function. The last being:
Set Variable $$CohortName
Let (N = Get(CurrentDate); Date(Year (N); &"-"& Month(N); & "- text string"
This is not working. What is wrong with this?