Calculation not working in month conversion

[bensons]

I am using a calulation of:

Right(Perf Date,4) & Middle(Perf Date, 3, 3) & Left(Perf Date, 2)

The format that I am calculating from is mm/day(Jun)/yyyy. As what is is stored is 09Nov1999

What I receive is yyyyNov09.

I am not sure how to format as this:

yyyymmdd

Thanks for your help.

[Chuck]

quote:

---

Originally posted by bensons:

I am using a calulation of:

Right(Perf Date,4) & Middle(Perf Date, 3, 3) & Left(Perf Date, 2)

The format that I am calculating from is mm/day(Jun)/yyyy. As what is is stored is 09Nov1999

What I receive is yyyyNov09.

I am not sure how to format as this:

yyyymmdd

Thanks for your help.

---

If Perf Date a date field try the following:

Year( Perf Date ) & Month( Perf Date ) & Day( Perf Date )

Chuck

[This message has been edited by Chuck (edited October 26, 2000).]

[Vaughan]

Trying to get date information out of a text field is not going to be very reliable as it will depend on whether people have entered leading zeros and typed in the full century etc.

If all that you want to achieve is for the date to be displayed in a particular way on a layout or in a report, you only need to use the Format:Date command and create a cuatom format that will automatically display the date in the format you desire. It cannot do everyhting but it may solve your problem here.

[This message has been edited by Vaughan (edited October 29, 2000).]