Support Forum - Date Funtions

06/05/2025 17:16 Jonny Herrera wrote: 

Greetings!!
Excuse me, is there a function in Fomin Report Builder that allows me to convert
a month number into its name?
For example:
monthName(2) returns 'February'
monthName(6) returns 'June'

I greatly appreciate any support you can provide with this request.

God bless you!!
06/06/2025 00:00 Ian Cook wrote: 

Hi Jonny

The simplest solution is to change the frame contents to use the clarion CHOOSE 
function.

For example.

=choose(month(INV:Date), 
'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec')

You can use you own functions but that is a bit more complicated.

Hope that helps.
06/06/2025 19:28 Jonny Herrera wrote: 

Hi Ian Cook...
Thank you so much for answering my question.
I'll follow your instructions and let you know the results.

Thanks again!!
06/09/2025 17:22 Jonny Herrera wrote: 

Hi Ian.
Thanks for the contribution.
It worked perfectly!!
Thank you very much.

Name:
E-Mail: (will not be published)
Subject:Date Funtions


Message body:

Verification code:

Please, do not include any URLs into the message.
Otherwise, your message will be rejected and IP blacklisted automatically.
Off topic messages will be deleted by moderator.