Hello,
I am having trouble getting a date formatted correctly. I just want the mm/dd to show in parenthesis. ie: (3/9)
It was working when I created the text boxes, but when I went to display the forms it didn't work.
In the control source, I am using a temp variable "TmpStartDate" and then adding 7 to each text box for each week.
=([TempVars]![TmpStartDate]+7) and then in the properties "Format" im using mm/dd
Any help would be appreciated
I am having trouble getting a date formatted correctly. I just want the mm/dd to show in parenthesis. ie: (3/9)
It was working when I created the text boxes, but when I went to display the forms it didn't work.
In the control source, I am using a temp variable "TmpStartDate" and then adding 7 to each text box for each week.
=([TempVars]![TmpStartDate]+7) and then in the properties "Format" im using mm/dd
Any help would be appreciated