Products Downloads


French version


 


ADELIA

VADELIA

SADELIA

WADELIA

EADELIA

(I/B)

(I/B)

(B)

(I/B)

(B)


Description

This predefined function is used to change the format of a six-position date.


Syntax

Result = &DATE6_FORMAT(Date;Initial format;Final format)


Parameters


Description

Contents

Controls

Result

Six-position numeric variable.

Date in the new format.


Date

Six-position numeric variable or constant.

Date to be reformatted.

Mandatory parameter.

Initial format

Three-position alphanumeric constant or variable.

Format of the date to be reformatted.

Possible values:

DMY Day/Month/Year

DYM Day/Year/Month

MDY Month/Day/Year

MYD Month/Year/Day

YMD Year/Month/Day

YDM Year/Day/Month

Mandatory parameter.

Final format

Three-position alphanumeric constant or variable.

Format into which the date set as a parameter must be transformed.

Possible values:

DMY Day/Month/Year

DYM Day/Year/Month

MDY Month/Day/Year

MYD Month/Year/Day

YMD Year/Month/Day

YDM Year/Day/Month

Mandatory parameter.


Example

* Management Rule of Initialize Property class (format YMD to DMY)

$$DATE = &DATE6_FORMAT($$DATE;'YMD';'DMY')


* Management Rule of Validate Property class (format DMY to YMD)

$$DATE = &DATE6_FORMAT($$DATE;'DMY';'YMD')


* in the ADELIA program

INITIALIZATION 01

CHAIN ORDERS

ZORDER_DATE = &DATE6_FORMAT(ZORDER_DATE;'YMD';'DMY')

* ...

VALIDATION 01

ZORDER_DATE = &DATE6_FORMAT(ZORDER_DATE;'DMY';'YMD')

STORE ORDERS


List of predefined functions by topic


↑ Top of page

  • Aucune étiquette