08-14-2024, 04:26 PM
Now see, if I was to write that, I'd have to do something like create a function there:
FUNCTION GetMonth$(month)
SELECT CASE month
CASE 1: GetMonth$ = "January"
...
END FUNCTION
And then I'd save that forevermore, and just copy/paste it as needed in any application that I ever wrote in the future that needs to convert numeric months to their string equivalent.
(And YES, if you look, you'll see that I do, indeed, have such a style function in my libraries for months, days, day of week, ect...
)
Write it once. If it works, use it forever!
FUNCTION GetMonth$(month)
SELECT CASE month
CASE 1: GetMonth$ = "January"
...
END FUNCTION
And then I'd save that forevermore, and just copy/paste it as needed in any application that I ever wrote in the future that needs to convert numeric months to their string equivalent.
(And YES, if you look, you'll see that I do, indeed, have such a style function in my libraries for months, days, day of week, ect...
)Write it once. If it works, use it forever!