Date issue 4

[maggielady]

I have a table that has a date field in this format: 08032005. I need to get that field in this format: yyyymmdd. Can someone help please? Thanks in advance.

 

[Eguy]

maggielady;

Assuming that OldDate = "08032005" and is MMDDYYYY

NewDate = RIGHT(OldDate,4) + LEFT(OldDate,2) + SUBSTR(OldDate,3,2)

Ed

Please let me know if the suggestion(s) I provide are helpful to you.
Sometimes you're the windshield... Sometimes you're the bug.

 

[bobmpalmer]

Maggie if you permenantly want all date fields to appear yyyymmdd then you can change the regional settings in control panel If however you only want this view or field in yr development you need to specify this in VFP's tools/options regional settings. If you want this to appear in this format in a field on a form then at class or object level you need to alter the property dateformat.

Bob Palmer

http://www.resisystems.co.uk

The most common solution is H2O!

 

[mspratt]

For a date field in a table just use DTOS(datefield).

Regards,

Mike

 

[TamarGranor]

Just to clarify what the others have said, if the field is actually defined as a Date field, then internally, it is stored as YYYYMMDD. In that case, the issue is how you display it, which you can control globally or locally.

If you have a character field that holds a date, Eguy's answer is the way to go.

Tamar

 

[maggielady]

Thanks to everyone and your answers, I got it and it works great! Thanks!!