Salesforce

Examples of Date Pictures (Magic xpi 4.9)

« Go Back

Information

 
Created BySalesforce Service User
Approval Process StatusPublished
Objective
Description

Examples of Date Pictures (Magic xpi 4.9)

The date used in the following examples is March 21, 1997. The contents of the date property are therefore 729103, which is the number of days from 01/01/0001.

Picture

Result and Notes

MM/DD/YY

03/21/97

DD/MM/YY

21/03/97

YY/MM/DD

97/03/21

DD/MM/YY

21-03-97 when the Date Separator parameter is set to -

DD-MM-YYYY

21-03-1997 where - is a mask character

YY.DDD

97.081

##/##/##

03/21/97, when the Date Mode property in the Magic.ini file is set to American

21/03/97, when the Date Mode property in the Magic.ini file is set to European

97/03/21, when the Date Mode property in the Magic.ini file is set to Scandinavian

MMMMMMMMMM^DDDD, ^YYYY

March^^^^^^21st,^1997

MMMMMMMMMM^DDDD, ^YYYYT

March^21st,^1997 with trimming directive

WWWWWWWWWW^-^W

Saturday^^^-^7

WWWWWWWWWW^-^WT

Saturday^-^7 with trimming directive

The ^ symbol represents a one-space character.

Reference
Attachment 
Attachment