Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Sumit Verma (SumitV24)
Amazon

Amazon
US
SumitV24 Member since 2015 23 posts
Amazon
Posted: Oct 14, 2015
Last activity: Sep 12, 2017
Posted: 14 Oct 2015 9:58 EDT
Last activity: 12 Sep 2017 21:19 EDT
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

To see attachments, please log in.

Accepted Solution

Posted: 9 years ago
Posted: 14 Oct 2015 12:06 EDT
Pankaj Rawal (rawap)
PEGA
Fellow, Software Architect, Platform Engineering
Pegasystems Inc.
IN

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

This should give you "October'

To see attachments, please log in.
Posted: 9 years ago
Posted: 14 Oct 2015 10:21 EDT
Gowrishankar Ramasamy (GowrishankarR29)
Citicorp Services India Private Limited

Citicorp Services India Private Limited
IN

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.

To see attachments, please log in.
Posted: 9 years ago
Posted: 14 Oct 2015 10:25 EDT
Rajiv Nistala (nistr) Senior Manager - Engineering
Pegasystems
IN

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.

To see attachments, please log in.
Posted: 7 years ago
Posted: 11 Sep 2017 10:47 EDT
Naresh RP (NareshRP)
Virtusa

Virtusa
IN

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>
To see attachments, please log in.
Posted: 7 years ago
Posted: 12 Sep 2017 21:19 EDT
Naresh RP (NareshRP)
Virtusa

Virtusa
IN

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

 

Show More

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>

Show Less
To see attachments, please log in.
Posted: 9 years ago
Posted: 14 Oct 2015 10:27 EDT
Brendan Horan (BrendanHoran)
PEGA
Director, GCS Knowledge Management
Pegasystems Inc.
US

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.

To see attachments, please log in.

Accepted Solution

Posted: 9 years ago
Posted: 14 Oct 2015 12:06 EDT
Pankaj Rawal (rawap)
PEGA
Fellow, Software Architect, Platform Engineering
Pegasystems Inc.
IN

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

This should give you "October'

To see attachments, please log in.
  • Srujan Kumar Goud Bollipally venkatesh Miryala Sumit Verma
Posted: 8 years ago
Posted: 22 Aug 2016 5:48 EDT
Bjorn Podlaha (bpodlaha76)
Capgemini Deutschland GmbH
Principal Business Analyst and PEGA CSSA
Capgemini Deutschland GmbH
DE

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”, “”,””)

To see attachments, please log in.

Related content:

Question Solved

Is there any OOTB function available to get the previous month name from current 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?

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 get Week number from 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 Solved

How to Split date from current System date?

Discussion

Is there any OOTB functionality available in PEGA for exchanging the file between the current and the external application?

Question

Needs to show past 6 month date from today's/current date in calendar.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice