Data Format

Stivan_dsouza21

I want Date format as 26/09/2011
now i m getting as 26/09/11
after using format i m getting as 26.september.2011


so I want Date format as 26/09/2011


How can i do it,
Thansk in advance

mohana_cse06

Have you read help on Format?

Or search the forum..you will get lot of posts..

Stivan_dsouza21

ya
but then too i m getting as 26. september 2011

mohana_cse06

Stivan_dsouza21 wrote:

ya
but then too i m getting as 26. september 2011

What did you read and implemented?

Stivan_dsouza21

Building Formats aND WHAT DID I IMPLEMENTED TAT I HAVE TOLD U FIRST TIME ITSELF

Stivan_dsouza21

thanks mohana
it has been done:

FORMAT(Date,0,'<Day,2>/<Month,2>/<Year4>')

mohana_cse06

Stivan_dsouza21 wrote:

Building Formats aND WHAT DID I IMPLEMENTED TAT I HAVE TOLD U FIRST TIME ITSELF

WHERE DID YOU MENTION WHAT YOU HAVE IMPLEMENTED?

Stivan_dsouza21 wrote:

after using format

FORMAT CAN BE USED WITH SOMANY PARAMETERS AND SOMANY WAYS..
HOW DO WE KNOW WHAT YOU HAVE WRITTEN... :?: :?: :?:

Stivan_dsouza21

THANKS MOHANA...........