1 of 1 people found this helpful
Assuming that period is an integer you could use ( dateadd('month',-([Period]-1), today()))
then set the date format as shown
if your period is a string Period 1 then convert the string to an integer int(right([Period],2)) and use teh above formula
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
That worked brilliantly. Thank you for your help.
Glad to help out
Please mark my original response correct to close the thread