I'm trying to print today's date at the top of a report in a format that spells out the month. I could do this with a data layer that selects sysdate from dual, but I would rather save the database call and use Logi functions. I know how to use logi functions to print the date as 01/10/2022 and 2022/01/10, but I'm looking for the value to put on a label that will give me:
January 10, 2022
MonthName() works fine if I feed it the month, but my syntax is wrong trying to get he monthname with this: =MonthName(=Month()). Setting a separate session variable to =Month() and then using =MonthName(@Session.month~) is also failing because of something syntax related.
Please sign in to leave a comment.