Date Format

[#1]

Is there a method to get the SAP date format?

(I could not find one).

[Former Member · Accepted solution]

The date format and seperator character are held on the OADM table, in the fields "DateFormat" and "DateSep". You can read these using a recordset object.

The DateFormat maps as follows:-

DateFormat = 0 -> DD/MM/YY

DateFormat = 1 -> DD/MM/YYYY

DateFormat = 2 -> MM/DD/YY

DateFormat = 3 -> MM/DD/YYYY

DateFormat = 4 -> YYYY/MM/DD

Below is a sample that identifies the date seperator, it would be easy to also include the date format.

'Identify the current date seperator character

Set sboRecordset = sboCompany.GetBusinessObject(BoRecordset)

strQuery = "SELECT datesep from oadm where currperiod = (select max(currperiod) from oadm)"

sboRecordset.DoQuery strQuery

sboRecordset.MoveFirst

mstrDateSeperator = sboRecordset.Fields(0).value

Regards,

John.

[Former Member · Accepted solution]

Thanks John.

[former_member374 · Accepted solution]

Hi Catherine,

You are thanking a poster for his answer.

Please next time also give him points.

See: /people/mark.finnern/blog/2004/08/10/spread-the-love

This time I did it for you.

Remember: When you ask a question you also assume the responsibility to assign points.

Please check your other questions and if the answers were good.

Spread the love and give some points.

Thanks in advance, Mark.