Informational : Format Date Specs

Some things in pdox get done so often it becomes second nature.
Other times, one sits and thinks, how the heck did I do that last time ?
Then, you must search for an example, or just figure it out again.

I am not sure how many times I have had to go into the help screen
and lookup the format specs.

After way too many trips to the help screen for the format command,
I finally got around to making a quick cheat sheet for myself.
and figured I would post it here as a community reference table.

Obviously there are many different ways to do this,
and I did not include all - but it is a starting point.

Lets take todays date , 2/14/2008,
and using the format command,
we can format that many, many different ways.

I will show two examples :
YYYYMMDD or YYYYMM

var
daVal date
stVal string
endvar

daVal = date("2/14/2008")

; to get YYYYMMDD or 20080214
stVal = format("DY3M2D2O(%Y%M%D)",daVal)
stVal.view("YYYYMMDD")

or

; to get YYYYMM or 20080214
stVal = format("DY3M2O(%Y%M)",daVal)
stVal.view("YYYYMM")

So that spells out two examples,
and the others are posted below.

Perhaps next time someone tries to remember one of these,
they can just google this page and cut and paste from here.

If there are any settings for windows or international
that affect these, I am not aware of them at this time,
and so I am not aware if/when your mileage may vary.


Robert Wiltshire



For the date of : 2/14/2008
daVal = date("2/14/2008")
stVal = format("DM1",daVal)

Spec Shorthand FormattedString
------ ----------- -----------------
DM1 m/dd/yy 2/14/08
DM2 mm/dd/yy 02/14/08
DM3 Mon/dd/yy Feb/14/08
DM4 Month/dd/yy February/14/08
DD1 mm/d/yy 02/14/08
DD2 mm/dd/yy 02/14/08
DY1 mm/dd/y 02/14/8
DY2 mm/dd/yy 02/14/08
DY3 mm/dd/yyyy 02/14/2008
D1 mm/dd/yy 02/14/08
D2 Monthname dd, yyyy February 14,2008
D3 mm/dd 02/14
D4 mm/yy 02/08
D5 dd-Mon-yy 14-Feb-08
D6 Mon yy Feb 08
D7 dd-Mon-yy 14-Feb-2008
D8 mm/dd/yyyy 02/14/2008
D9 dd.mm.yy 14.02.08
D10 dd/mm/yy 14/02/08
D11 yy-mm-dd 08-02-14
DY3M2O(%Y%M) YYYYMM 200802
DY3M2D2O(%Y%M%D) YYYYMMDD 20080214
DY3M2D2O(%Y/%M/%D) YYYY/MM/DD 2008/02/14
DY3M2D2O(%Y-%M-%D) YYYY-MM-DD 2008-02-14
DD2O(%D) DD 14
DM2O(%M) MM 02
DY2O(%Y) YY 08
DY3O(%Y) YYYY 2008

Another point is the MODE in the BDE (System-Formats-Date)
You do not always obtain the same results if you use MODE 0, 1 or 2
Régis


"Robert Wiltshire" a écrit dans le message de
47b49e62$1@pnews.thedbcommunity.com...
>
> Some things in pdox get done so often it becomes second nature.
> Other times, one sits and thinks, how the heck did I do that last time ?
> Then, you must search for an example, or just figure it out again.
>
> I am not sure how many times I have had to go into the help screen
> and lookup the format specs.
>
> After way too many trips to the help screen for the format command,
> I finally got around to making a quick cheat sheet for myself.
> and figured I would post it here as a community reference table.
>
> Obviously there are many different ways to do this,
> and I did not include all - but it is a starting point.
>
> Lets take todays date , 2/14/2008,
> and using the format command,
> we can format that many, many different ways.
>
> I will show two examples :
> YYYYMMDD or YYYYMM
>
> var
> daVal date
> stVal string
> endvar
>
> daVal = date("2/14/2008")
>
> ; to get YYYYMMDD or 20080214
> stVal = format("DY3M2D2O(%Y%M%D)",daVal)
> stVal.view("YYYYMMDD")
>
> or
>
> ; to get YYYYMM or 20080214
> stVal = format("DY3M2O(%Y%M)",daVal)
> stVal.view("YYYYMM")
>
> So that spells out two examples,
> and the others are posted below.
>
> Perhaps next time someone tries to remember one of these,
> they can just google this page and cut and paste from here.
>
> If there are any settings for windows or international
> that affect these, I am not aware of them at this time,
> and so I am not aware if/when your mileage may vary.
>
>
> Robert Wiltshire
>
>
>
> For the date of : 2/14/2008
> daVal = date("2/14/2008")
> stVal = format("DM1",daVal)
>
> Spec Shorthand FormattedString
> ------ ----------- -----------------
> DM1 m/dd/yy 2/14/08
> DM2 mm/dd/yy 02/14/08
> DM3 Mon/dd/yy Feb/14/08
> DM4 Month/dd/yy February/14/08
> DD1 mm/d/yy 02/14/08
> DD2 mm/dd/yy 02/14/08
> DY1 mm/dd/y 02/14/8
> DY2 mm/dd/yy 02/14/08
> DY3 mm/dd/yyyy 02/14/2008
> D1 mm/dd/yy 02/14/08
> D2 Monthname dd, yyyy February 14,2008
> D3 mm/dd 02/14
> D4 mm/yy 02/08
> D5 dd-Mon-yy 14-Feb-08
> D6 Mon yy Feb 08
> D7 dd-Mon-yy 14-Feb-2008
> D8 mm/dd/yyyy 02/14/2008
> D9 dd.mm.yy 14.02.08
> D10 dd/mm/yy 14/02/08
> D11 yy-mm-dd 08-02-14
> DY3M2O(%Y%M) YYYYMM 200802
> DY3M2D2O(%Y%M%D) YYYYMMDD 20080214
> DY3M2D2O(%Y/%M/%D) YYYY/MM/DD 2008/02/14
> DY3M2D2O(%Y-%M-%D) YYYY-MM-DD 2008-02-14
> DD2O(%D) DD 14
> DM2O(%M) MM 02
> DY2O(%Y) YY 08
> DY3O(%Y) YYYY 2008
>
>
>
>
>