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?

Question

8
Replies
12765
Views
Close popover
Sumit Verma (SumitV24)
Amazon

Amazon
US
View Profile
SumitV24 Member since 2015 23 posts
Amazon
Posted: October 14, 2015
Last activity: September 12, 2017
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: 5 years ago
Close popover
Gowrishankar Ramasamy (GOWRISHANKAR)
PEGA
Sr. Service Assurance Advisor Specialist
Pegasystems Inc.
IN
View Profile

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: 5 years ago
Close popover
Rajiv Nistala (nistr)
PEGA
Senior Manager - Engineering
Pegasystems
IN
View Profile

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: 5 years ago
Close popover
Brendan Horan (BrendanHoran_GCS)
MOD
Technical Director, Global Client Support
Pegasystems Inc.
US
View Profile

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

Thanks.

B.

Posted: 3 years ago
Close popover
Naresh RP (NareshRP)
Virtusa

Virtusa
IN
View Profile

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
Close popover
Naresh RP (NareshRP)
Virtusa

Virtusa
IN
View Profile

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: 5 years ago
Close popover
Brendan Horan (BrendanHoran_GCS)
MOD
Technical Director, Global Client Support
Pegasystems Inc.
US
View Profile

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: 5 years ago
Close popover
Pankaj Rawal (rawap)
PEGA
Sr Architect, Case Management
Pegasystems Inc.
IN
View Profile

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

This should give you "October'

Posted: 4 years ago
Close popover
Bjorn Bachmann (bbachmann76)
metafinanz Informationssysteme
Principal Business Analyst and PEGA CSSA
metafinanz Informationssysteme
DE
View Profile

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 Share via LinkedIn Copying...
Copied!