How to convert date field to number value

Using a custom format for the cell you can rearrange the order. By going into the Format menu then Cell menu. In the Number tab scroll to custom and input "yyymmdd" without the quotes and the cell will display the date in the order you wanted.

sorry that was supose to be "yyyymmdd" good luck.

Thanks for your help I really appreciate it. It worked great.