This content has been marked as final.
Show 3 replies
-
1. Re: Return a text name
Peter Fakan Jul 17, 2017 4:05 PM (in response to Alex Martino)Hi Alex,
If I understand your requirement properly, create a calculated field using the following syntax:
Case [Parameter name]
when "1" then "January"
when "2" then "February" ~etc
end
Then insert this calculated field into your text box
HTH
Peter
-
2. Re: Return a text name
Alex Martino Jul 17, 2017 4:56 PM (in response to Alex Martino)Thanks. Is there no date function that will convert a number into a month?
-
3. Re: Return a text name
Chris McClellanJul 17, 2017 5:43 PM (in response to Alex Martino)
But "1" isn't really a date, does 1 mean the first month of this year ? calendar year or fiscal year ?
You can take the "1", and add in the other values as part of the MAKEDATE function, but why not just have the user choose the date in the parameter ?