 | |
Informational : Format Date Specs
comp.databases.paradox comp.databases.paradox
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Informational : Format Date Specs -
02-14-2008
, 02:03 PM
#2
| |||
| |||
|
|
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 |
#3
| |||
| |||
|
|
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 |
#4
| |||
| |||
|
|
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 |
#5
| |||
| |||
|
|
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 |
#6
| |||
| |||
|
|
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 |
#7
| |||
| |||
|
|
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 |
#8
| |||
| |||
|
|
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 |
#9
| |||
| |||
|
|
Lets take todays date , 2/14/2008, |
#10
| |||
| |||
|
|
Lets take todays date , 2/14/2008, |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.