mrc logo mrc logo
  • m-Power m-Power
    What is m-Power?
    Overview Demos Build Process Case Studies Specs Pricing Trial
    m-Power Resources
    Overview How-To Videos Webinars & Podcasts White Papers Fact Sheets
  • Solutions Solutions
    What does m-Power build?
    Overview Database Front-Ends Reporting CRM Systems Business Intelligence Dashboards Mobile Apps ERP Enhancements Modernization Spreadsheets to the web MS Access to the web B2B/Web Portals Scheduling Embedded Analytics Web Forms Workflow Data Exploration Budgeting & Forecasting APIs and Web Services
    Solutions by Industry
    Overview Manufacturing Government Foodservice Software Vendors Logistics & Supply Chain Software Consultants Healthcare
  • Services Services
    Overview Training Project Consulting Staff Consulting Mentoring
  • About About
    Overview Partners Press Releases Careers Events Contact Blog
  • Support Support
    Support Home FAQ Documentation Customer Portal Enhancements Updates Roadmap Techblog
Try m-Power

m-Power Manual

Browse:

  • Home
  • Dates

Date/Time Formatting

Working with True Dates & True Timestamps   m-Power is proud to announce the new Date/Time enhancement. Now, m-Power is stronger than ever when using true dates and true timestamps within your applications by being able to handle any display format as well as work with any database date/timestamp format. What this means is m-Power […]

Tags: Calendar Helper, Dates, Timestamps

JDEDateConvert Source Code

JDEDateConvert Source Code   package com.abc_co.mrcextension; import java.math.BigDecimal; import java.text.DateFormat; import java.text.ParseException; import java.text.SimpleDateFormat; import java.util.Calendar; import java.util.Date; import java.util.regex.Matcher; import java.util.regex.Pattern; import com.mrc.ext.FieldConvertAbstract; /**  *  Sample class to convert display value to db value and vice versa.  *  (cyynnn  mmddyy)  *  * (1) Custom class must extend com.mrc.ext.FieldConvertAbstract  *     (which is in mrcapps.jar)  * (2) Implement method dbValue(String s) to Convert display string to DB value  * (3) Implement method customNumber(BigDecimal value) to convert db value  *     to display value.  * (4) Implement editInput() to edit input value.  * (5) If you are converting a character field, Implement method  *     customString(String value) to convert db value to display value.  * (6) Make a jar file and put it in folder m-power/mrcjava/WEB-INF/lib.  * (7) Attach this class to the field you want to convert in  *     Update Dictionary Field screen.  *  */ public class JDEDateConvert extends  FieldConvertAbstract {     /** Default cyynnn value for incorrect input */     static String dftVal = "99999";     /*********************************************************************      * Convert display string mmddyy to DB value cyynnn      *********************************************************************/     public String dbValue(String dspstr) {         if (dspstr == null || dspstr.toUpperCase().indexOf("*BLANK")>=0) {             return "0";         }         //if passed as mm/dd/yy instead of mmddyy         if (dspstr.indexOf("/") > 0) {             String msg = check(dspstr);             if (msg != null) {                 return dftVal;             }             dspstr = dspstr.replaceAll("/", "");         }         String str = dspstr;         int year = 0;         String cyynnn = "";         if (str.length() == 6) { //mmddyy             String mm = str.substring(0,2);             String dd = str.substring(2,4); […]

Tags: Dates

Create Calendar Helper in m-Painter

Create Calendar Helper in m-Painter   To implement the Calendar Helper functionality in your application, open m-Painter. Click on the input field to which you would like the calendar functionality applied. Either select the "Calendar" button from the m-Painter toolbar or right-click on your input field, and select "Insert/Edit Calendar". If you see the below […]

Tags: Calendar Helper, Dates, m-Painter, Popular

Calculation Screen

Calculation Screen Calculation Features Calculation Types Creating Calculations Calculation Features Calculations as Sequence keys and Record Selection fields — Calculations have been designed to take full advantage of SQL. Nearly every calculation is available to use as a sequence field or record selection field. Sequence/Record Selection Availability — The Work-with Calculation screen shows which calculations […]

Tags: Application Calculations, Calculations, Conditional Calculations, Database Calculations, Dates, External Objects, Parameter Calculations, SQL, System Variables

Add/Subtract Dates using the Java Date Translator

Add/Subtract Dates using the Java Date Translator **Note: This Feature Has Been Deprecated. Please use this link to find alternative features: https://www.mrc-productivity.com/techblog/?p=522     The Java Date Translator is a very powerful tool, commonly used to determine the difference between two dates (Most date conversion can now be accomplished with a UDF). However, there is […]

Tags: Calculations, Dates, Java, Java Date Translator

mrc Date Conversion UDFs

mrc Date Conversion UDFs (User-Defined Functions)   mrc supplies three date conversion routines specifically for AS/400 databases. These routines are SQL functions located in MRCAPPLLIB, and they are available for use in logical and calculated fields. All three UDFs take a numeric date as an input parameter. Function specifications are described below. UDF Name Description […]

Tags: Advanced, Dates, External Objects, UDF

Introduction to User Defined Functions (UDF)

UDF Introduction   All applications created with m-Power employ SQL to access the database. SQL, by itself, is a very powerful language. A database User Defined Function (UDF) allows users to extend the power of SQL. UDF's are a powerful yet simple way to perform routine data transformations, calculations, and complex SQL logic. Database vendors […]

Tags: Dates, Logical Fields, UDF

Java Date Translator

Java Date Translator (External Object) **NOTE: This Functionality Has Been Deprecated. Please use this link to see alternative features: https://www.mrc-productivity.com/legacy/external-objects-udf/mrc-date-conversion-udfs   mrc supplies a date translator specifically for use with generated Web/Servlet applications. This Java class is named mrc.servlet.MrcDateTranslator and resides in mrcextobj.jar. The object definition is shown below. If this object definition is not […]

Tags: Calculations, Dates, Java, Java Date Translator

Search

Browse By Category

Build Process (13)
Starting with m-Power (8)
Retrievals (10)
Reports (15)
Summaries (4)
Maintainers (17)
Graphs (8)
m-Power Data Explorer (4)
General (24)
Calculations (5)
Utilities (9)
m-Power Administration (23)
Security (11)
Freemarker (6)
m-Painter (29)
Form Validation (5)
External Objects & UDFs (12)
Deprecated Documentation (23)
Bootstrap Templates (7)

Popular Tags

Compiling SQL Admin Form Validation m-Painter Freemarker RPG Maintainers Maintainer Bar Graphs Advanced Tomcat Administration Build Process Record Selections Java Security Retrieval Popular Dates Graphing Dropdowns Calculations Video Parameters DB2 Graphs Summaries Performance Prompt Screens Excel Reports Database Bootstrap Templates Production External Objects Data Dictionary Retrievals App Properties Application Properties Graph Properties mrc-Productivity Series Email Report Getting Started

See all tags »

michaels, ross & cole, ltd. (mrc)
Privacy Settings Privacy Policy Cookie Policy Employee Intranet
© 2018 mrc. All rights reserved.
mrc (US)

2001 Midwest Road
Suite 310
Oak Brook, IL 60523
630-916-0662

mrc (UK)

Mortlake Business Centre
20 Mortlake High Street
London, SW14 8JN
+44-20-335-59566