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 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
  • m-Painter
  • Create Calendar Helper in m-Painter
Back to Manual

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 error message, it means you did not first select an input box before creating your calendar. Therefore, m-Painter does not know which input your calendar should belong to and throws the message you see below:

Once you have specified an input box, you will be shown this dialog box. Each option is outlined below:

Select a date format — You must select the format that matches your date's format in the database. The list below contains all valid options and also an example of how a sample date (July 4, 2010) would be represented for each format:

  • ymmdd (100704)
  • mmdd (20100704)
  • yy-mm-dd (2010-07-04)
  • yy/mm/dd (2010/07/04)
  • mmddyy (07042010)
  • mm/dd/yy (07/04/2010)
  • mm-dd-yy (07-04-2010)
  • mmddy (070410)
  • mm/dd/y (07/04/10)
  • mm-dd-y (07-04-10)
  • ddmmy (040710)
  • dd/mm/y (04/07/10)
  • dd-mm-y (04-07-10)
  • ddmmyy (04072010)
  • dd/mm/yy (04/07/2010)
  • dd-mm-yy (04-07-2010)
  • dd-M-yy (04-JUL-2010)
  • dd-M-y (04-JUL-10)
  • yy-M-dd (2010-JUL-04)
  • y-M-dd (10-JUL-04)

You'll notice that references with "Y" indicate a 2 digit year, whereas a reference with "YY" indicates a 4 digit year.

Min Date & Max Date — These two input boxes are useful if you want to limit the user to selecting dates within a range. For instance, specifying "-30" in the Min Date input & "+30" in the Max Date input forces your user to select a date within the past 30 days through a date 30 days in the future. To specify periods of time, use D for days, W for weeks, M for months, or Y for years. For instance, specifying "+1Y2W" for Max Date will only allow dates to be selected up to one year and 2 weeks from the current date.

# of Months — This feature allows you to control the number of months that appear when a user selects the pop-up calendar. By default, the option is 1 month at a time; however, the current maximum number of months to see simultaneously is 4.

Show Month/Year Selections? — This feature, when checked, allows the user to quickly switch to a different month or year, rather than paging through each month.

Apply to Field — This option tells m-Painter which input box owns the calendar picker. The value in this input box is decided by which field you clicked on when you created the calendar picker and does not need to be modified.

Once you have made all the changes you would like, please click "Save". Run your application.

Release notes

  • The method of creating calendar helpers with the User Defined Field Code of "C" will continue to work to support older applications, but has been deprecated.
  • If specifying min and max date, you must enter "-" and "+" within the respective input boxes.
  • If an end-user selects "Today" from the calendar, they will be returned to the current month. However, no date will be returned to the form unless directly clicked on.
  • m-Power ships with 20 of the most popular formats. However, you have the option to customize your date format by ignoring the "Select a data format" drop-down list, and instead typing in your own format into the "Selected Format" input box. Your date format can be combinations of the following:
    • d – day of month (no leading zero)
    • dd – day of month (two digit)
    • o – day of year (no leading zero)
    • oo – day of year(three digit)
    • D – day name short
    • DD – day name long
    • m – month of year (no leading zero)
    • mm – month of year (two digit)
    • M – month name short
    • MM – month name long
    • y – year (two digit)
    • yy – year (four digit)
    • ! – Windows ticks (100ns since 01/01/0001)
    • @ – Unix timestamp (also known as epoch seconds or POSIX time) in milliseconds since 01/01/1970
    • '…' – literal text
    • " – single quote
    • anything else – literal text

Created: February 15, 2010 | Modified: August 18, 2017

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

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

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