Related content:

Question Is there any function available in pega to return the day name for a given date? Question Is there any function available in pega to return the day name for a given date? Question Is there any function available in pega to return the day name for a given date? Discussion How to get current date? Question Is there OOTB function(s) to get difference between two dates in months and dates? Question How to Split date from current System date? Question Is there any Pega OOTB function available to Strip the Invalid Characters from String ? Discussion Is there any OOTB functionality available in PEGA for exchanging the file between the current and the external application? Question Is there any OOTB Pega function to convert any valid date to MM/DD/YYY Question Is there anyway to get a Julian date function quickly or maybe an OOTB function?
Contact a Moderator

Question

8
Replies
12456
Views
SumitV24 Member since 2015 23 posts
Amazon
Posted: 4 years ago
Last activity: 3 years ago
Closed
Solved

Is there any OOTB function available to get the month name from current date?

Example - If I use this function today; it should give October

Close popover
Moderation Team has archived post
Posted: 4 years ago

Hi Sumit,

           There is an OTTB function "@DateTime.month(pegaRulesDate)" , this will return the numeric values between '0 to 11' . here 0 indicate 'January', etc..

You can create decision rule to set the string values appropriately.

here pegaRulesDate value for today is 20151014 (yyyymmdd)

Please let me know if this helps,

Thanks,

Gowrishankar.

Posted: 4 years ago

The same applies to SQL functions if you are referring to report definitions. pxMonthNumber function will give you the number and you can use a control to show the right name based on the number.

Posted: 4 years ago

Oh nice! Or just use that control that Rajiv just mentioned. Even better

Thanks.

B.

Posted: 3 years ago

To see the months in Report you need to write the source with custom Function alias like pxMonthNumber with "Text" return type.


<p:choose>


<p:when test=".pyParameters(1).pyUserEnteredDataType == 'DATE'">


    (CASE WHEN {1} IS NOT NULL


       THEN


       SUBSTRING (CONVERT(VARCHAR,{1},100),1,3)+' '+CAST(DATEPART(YYYY,{1}) AS VARCHAR)         


    END)  


</p:when>


<p:when test=".pyParameters(1).pyUserEnteredDataType == 'DATETIME'">


     <p:choose>


         <p:when test=".pyParameters(1).pyDBDataType == 'DATETIME'">


 


     SUBSTRING (CONVERT(VARCHAR,{1},100),1,3)+', '+CAST(DATEPART(YYYY,{1}) AS VARCHAR)         


         </p:when>


<p:otherwise>


(CASE WHEN {1} IS NOT NULL 


          THEN SUBSTRING (CONVERT(VARCHAR,{1},100),1,3)+' '+CAST(DATEPART(YYYY,{1}) AS VARCHAR)


          END)


</p:otherwise>


     </p:choose>


</p:when>


</p:choose>

Posted: 3 years ago

To display Quarterly like Jan-Mar, 2017 or Apr-Jun, 2017, we can add new Function  alias as below, with return type "Text",


 


<p:choose>


<p:when test=".pyParameters(1).pyUserEnteredDataType == 'DATE'">


    (CASE WHEN {1} IS NOT NULL


       THEN


        SUBSTRING(datename(month, DATEADD(QUARTER, DATEDIFF(QUARTER, 0, {1}), 0)  ),1,3)+'-'+SUBSTRING(datename(month, (DATEADD(month, 2, DATEADD(QUARTER, DATEDIFF(QUARTER, 0, {1}), 0)  ) ) ),1,3)+ ' , ' +SUBSTRING(CAST(DATEPART(YYYY,{1}) AS VARCHAR),1,4)        


    END)  


</p:when>


<p:when test=".pyParameters(1).pyUserEnteredDataType == 'DATETIME'">


     <p:choose>


         <p:when test=".pyParameters(1).pyDBDataType == 'DATETIME'">


 


      SUBSTRING(datename(month, DATEADD(QUARTER, DATEDIFF(QUARTER, 0, {1}), 0)  ),1,3)+'-'+SUBSTRING(datename(month, (DATEADD(month, 2, DATEADD(QUARTER, DATEDIFF(QUARTER, 0, {1}), 0)  ) ) ),1,3)+ ' , ' +SUBSTRING(CAST(DATEPART(YYYY,{1}) AS VARCHAR),1,4)            


         </p:when>


<p:otherwise>


(CASE WHEN {1} IS NOT NULL 


          THEN  SUBSTRING(datename(month, DATEADD(QUARTER, DATEDIFF(QUARTER, 0, {1}), 0)  ),1,3)+'-'+SUBSTRING(datename(month, (DATEADD(month, 2, DATEADD(QUARTER, DATEDIFF(QUARTER, 0, {1}), 0)  ) ) ),1,3)+ ' , ' +SUBSTRING(CAST(DATEPART(YYYY,{1}) AS VARCHAR),1,4)    


          END)


</p:otherwise>


     </p:choose>


</p:when>


</p:choose>

Posted: 4 years ago

Adding to the previous response, I think the combination of functions will get you what you need.

@DateTime.month(@DateTime.dateValue(@DateTime.getCurrentDateStamp()))

As mentioned, the function will return an integer. So if you want to actually have the text date set on the property, you'd have to write something like a very simple data transform to set the text based on the value returned.

Thanks.

B.

Accepted Solution
Posted: 4 years ago

@(Pega-RULES:DateTime).FormatDateTime(@(Pega-RULES:DateTime).CurrentDateTime(), "MMMMM", "", "")

This should give you "October'

Posted: 4 years ago

Hint: if your dates are configured as "Date only" properties you must add the term "T000000.000 GMT" to work the function as described above.


Example:


Set. ContractStartMonth equal to (@DateTime.FormatDateTime(.ContractStartDate + "T000000.000 GMT", “MMMMM”, “”,””)
Share this page LinkedIn
Copied!