Data Center Management Systems


Date Control System - Technical Overview                                     Download DCS today!


DCS consists of 3 main components:


The DCS Access Routine provides 34 date calculation services from the simple to the complex.

Access Command Summary
Command Description Input Output Calendar
AD Advance Date by specified days MMDDYY MMDDYY+nnn  
AWD Advance Working Days by specified days using holiday calendar MMDDYY MMDDYY+nnn HOLIDAY
BD Backspace Date by specified days MMDDYY MMDDYY+nnn  
BWD Backspace Working Days by specified days using holiday calendar MMMMDDYYDDYY   HOLIDAY
CURR Return current system date and time   MMDDYY HHMMSS  
DBD Return number Days Between 2 Dates MMDDYY nnn  
DAYS Days Remaining in calendar Year MMDDYY nnn  
DDMM Shift DDMMYY to MMDDYY DDMMYY MMDDYY  
DDYY Shift DDMMYY to YYMMDD DDMMYY YYMMDD  
DOW Return Day of the Week MMDDYY MONDAY-SUNDAY  
ED Edit (validate) Date MMDDYY coded  
EP Elapsed Periods, returns period (month) number within fiscal calendar MMDDYY nnn FISCAL
EXP Expand Date, returns written date MMDDYY January 4, 2017  
FPWN Fiscal Period Week Number, returns week number within fiscal month MMDDYY nnn  
FYWN Fiscal Year Week Number, returns week number within fiscal year MMDDYY nnn  
GJ Converts date from Gregorian to Julian formats MMDDYY YYDDD  
GJYY Gregorian to Julian - 4-digit year MMDDYYYY YYYDDD  
IS Insert Slashes MMDDYY MM/DD/YY  
ISYY Insert Slashes - 4-digit year MMDDYYYY MM/DD/YYYY  
JG Convert date from Julian to Gregorian formats YYDDD MMDDYY  
JGYY Julian to Gregorian - 4-digit year YYYYDDD MMDDYYYY  
MBD Returns Month Beginning Date for specified date MMDDYY MMDDYY-ddd  
MED Returns Month Ending Date for specified date MMDDYY MMDDYY-ddd  
MMDD Shift MMDDYY to DDMMYY MMDDYY DDMMYY  
MMYY Shift MMDDYY to YYMMDD MMDDYY YYMMDD  
PBD Returns Period Beginning Date for specified date in fiscal calendar MMDDYY MMDDYY-ddd FISCAL
PED Returns Period Ending Date for specified date in fiscal calendar MMDDYY MMDDYY+ddd FISCAL
RET Retrieve Date from stored array   MMDDYY  
RS Remove Slashes MM/DD/YY MMDDYY  
RSYY Remove Slashes - 4-digit year MM/DD/YY YY MMDDYYYY  
UPD Update Date into stored array MMDDYY    
WD Working Day Inquiry, answers “is this date a non-holiday?” MMDDYY

YES or NO

HOLIDAY
WDBD Returns number of Working Days Between 2 Dates using holiday calendar MMDDYY nnn HOLIDAY
YYMM Shift YYMMDD to MMDDYY YYMMDD MMDDYY  

Formats: Most calculations use the default format MMDDYY for both input and output dates, but can be overridden to any of these formats: MMDDYYYY, YYMMDD, YYYYMMDD, DDMMYY, and DDMMYYYY.
Calendar: Those calculations identified with a HOLIDAY or FISCAL calendar require prior setup with the DCS Utility program.  




The DCS Utility program is used to:
Utility Command Summary

Command

Description

Category

CALENDAR

Initialize holiday calendar for one year

HOLIDAY

DELETE HOLIDAY

Delete holiday calendar

HOLIDAY

DISPLAY HOLIDAYS

Show all stored holidays for calendar

HOLIDAY

PASSWORD HOLIDAY

Set or change calendar password

HOLIDAY

PRINT HOLIDAY

Create printable annual holiday calendar

HOLIDAY

WORKINGDAY

Correct days on holiday calendar

HOLIDAY

 

 

 

FISCAL

Initialize fiscal calendar for one year

FISCAL

ADJUST

Correct fiscal calendar ending period

FISCAL

DELETE FISCAL

Delete fiscal calendar

FISCAL

PRINT FISCAL

Create printable annual fiscal calendar

FISCAL

PASSWORD FISCAL

Set or change calendar password

FISCAL

 

 

 

JOBDATE

Store JOBDATE code or actual date

JOBDATE

DISPLAY JOBDATES

Show all JOBDATES

JOBDATE

 

 

 

CONTROL

Initialize data storage array for application

DATES

DISPLAY DATES

Show data storage array for application

DATES

PASSWORD DATE

Set or change array password

DATES

PROTECT

Set or change password on data array element

DATES

RESTORE

Revert data array to previous generation

DATES

SETDATE

Set value for application data array element

DATES




DCS’s JOBDATE facility lets you automate the handling of dates within batch processing. Two methods are provided for implementing JOBDATE:

Many JOBDATE codes are pre-defined as shown below. To meet your site-specific needs, user-defined codes can be added easily.


Jobdate Codes

Category

Code

Condition

Description

Sample Input

Sample Output

CALENDAR

BMnn

Always

Backspace 'nn' months

BM02 on 10/02/16
BM06 on 05/31/16

8/02/2016
11/30/2015

CALENDAR

FMnn

Always

Forward space 'nn' months

FM07 on 06/02/16
FM01 on 10/31/16

01/02/2007
11/30/2016

CALENDAR

LMBD

Always

Previous month's month-begin date

4/8/2016

3/1/2016

CALENDAR

LMED

Always

Previous month's month-ending date

4/8/2016

3/31/2016

CALENDAR

NMBD

Always

Next month's month-begin date

4/8/2016

5/1/2016

CALENDAR

NMED

Always

Next month's month-ending date

4/8/2016

5/31/2016

CALENDAR

SABD

Always

Semi-Annual begin date just ended

7/2/2016
1/5/2007

1/1/2016
7/1/2016

CALENDAR

SAED

Always

Semi-Annual ending date just ended

7/2/2016
1/5/2007

6/30/2016
12/31/2016

CALENDAR

TMBD

Always

Current month's month-begin date

4/8/2016

4/1/2016

CALENDAR

TMED

Always

Current month's month-ending date

4/8/2016

4/30/2016

CURR

CURR *

Always

Current date

2/14/2016

2/14/2016

CURR

DALY *

06:00 - 23:59

Current date

2/14/2016 13:30

2/14/2016

CURR

DALY *

00:00 - 05:59

Yesterday's date

2/14/2016 1:30

2/13/2016

CURR

NOON *

12:00 - 23:59

Today's date

2/14/2016 14:30

2/14/2016

CURR

NOON *

00:00 - 11:59

Yesterday' date

2/14/2016 2:30

2/13/2016

FRI

AFRI

Always

Advance to Friday

Today is Friday
Today is Thursday

Next Friday's date
Tomorrow's date

FRI

BFRI

Always

Backspace to Friday

Today is Friday
Today is Saturday

Last week
Yesterday's date

FRI

LFRI

Always

Last Friday's date

Today is Friday
Today is Saturday

Today's date
Yesterday's date

FRI

NFRI

Always

Next Friday's date

Today is Friday
Today is Thursday

Today's date
Yesterday's date

HOLIDAY

LBD *

Always

Last business (non-holiday) day

6/2/2016
6/5/2016

6/1/2016
6/2/2016

HOLIDAY

NBD *

17:00 - 23:59

Next business date

6/7/2016 17:30

6/8/2016

HOLIDAY

NBD *

00:00 - 16:59

Current date

6/7/2016 16:30

6/7/2016

HOLIDAY

NBD *

On a holiday

Next business (non-holiday) day

6/3/2016 5:30

6/5/2016

MON

AMON

Always

Advance to Monday

Today is Monday
Today is Sunday

Next Monday's date
Tomorrow's date

MON

BMON

Always

Backspace to Monday

Today is Monday
Today is Tuesday

Last week
Yesterday's date

MON

LMON

Always

Last Monday's date

Today is Monday
Today is Tuesday

Today's date
Yesterday's date

MON

NMON

Always

Next Monday's date

Today is Monday
Today is Sunday

Today's date
Tomorrow's date

MON

TMON

Always

Next Monday's date

Today is Monday
Today is Sunday

Today's date
Tomorrow's date

FISCAL

LPBD

Always

Last period begin date

 

 

FISCAL

LPED

Always

Last period end date

 

 

FISCAL

LPYY

Always

Last period number and year

 

 

FISCAL

NPBD

Always

Next period begin date

 

 

FISCAL

NPED

Always

Next period end date

 

 

FISCAL

QTR#

Always

Quarter number of period just ended

5/31/2016

2

FISCAL

TPBD

Always

Current period begin date

 

 

FISCAL

TPED

Always

Current period end date

 

 

FISCAL

TPYY

Always

Current period number and year

 

 

SAT

ASAT

Always

Advance to Saturday

Today is Saturday
Today is Friday

Next Saturday's date
Tomorrow's date

SAT

BSAT

Always

Backspace to Saturday

Today is Saturday
Today is Sunday

Last week
Yesterday's date

SAT

LSAT

Always

Last Saturday's date

Today is Saturday
Today is Sunday

Today's date
Yesterday's date

SAT

NSAT

Always

Next Saturday's date

Today is Saturday
Today is Friday

Today's date
Tomorrow's date

SUN

ASUN

Always

Advance to Sunday

Today is Sunday
Today is Saturday

Next Sunday's date
Tomorrow's date

SUN

BSUN

Always

Backspace to Sunday

Today is Sunday
Today is Monday

Last week
Yesterday's date

SUN

LSUN

Always

Last Sunday's date

Today is Sunday
Today is Monday

Today's date
Yesterday's date

SUN

NSUN

Always

Next Sunday's date

Today is Sunday
Today is Saturday

Today's date
Tomorrow's date

THU

ATHU

Always

Advance to Thursday

Today is Thursday
Today is Wednesday

Next Thursday's date
Tomorrow's date

THU

BTHU

Always

Backspace to Thursday

Today is Thursday
Today is Friday

Last week
Yesterday's date

THU

LTHU

Always

Last Thursday's date

Today is Thursday
Today is Friday

Today's date
Yesterday's date

THU

NTHU

Always

Next Thursday's date

Today is Thursday
Today is Wednesday

Today's date
Tomorrow's date

TUE

ATUE

Always

Advance to Tuesday

Today is Tuesday
Today is Monday

Next Tuesday's date
Tomorrow's date

TUE

BTUE

Always

Backspace to Tuesday

Today is Tuesday
Today is Wednesday

Last week
Yesterday's date

TUE

LTUE

Always

Last Tuesday's date

Today is Tuesday
Today is Wednesday

Today's date
Yesterday's date

TUE

NTUE

Always

Next Tuesday's date

Today is Tuesday
Today is Monday

Today's date
Tomorrow's date

WED

AWED

Always

Advance to Wednesday

Today is Wednesday
Today is Tuesday

Next Wednesday's date Tomorrow's date

WED

BWED

Always

Backspace to Wednesday

Today is Wednesday
Today is Thursday

Last week
Yesterday's date

WED

LWED

Always

Last Wednesday's date

Today is Wednesday
Today is Thursday

Today's date
Yesterday's date

WED

NWED

Always

Next Wednesday's date

Today is Wednesday
Today is Tuesday

Today's date
Tomorrow's date



DCS includes the following manuals.

DCS Administrator Guide
DCS User Guide
DCS Upgrade Guide


The DCMS support line is available 7 days/week, 24 hours/day.


For additional information, contact your DCMS Representative at (952)473-3572 or sales@dcmsi.com.