SQL Date question

[Ted Young]

I am trying to return/build a date that is based on 2 other dates from a table.

For example, the date is equal to the Month of one date and the Year-1 of
another date (the day is always 01).

How can I build this date?

Any ideas or suggestions would be greatly appreciated.

Thanks!

Ted

[DaveSatz]

Access, SQL Server, Oracle....
"Ted Young" <tedyoung@connecticare.com> wrote in message
news:3b94d52b$1@news.devx.com...
>
> I am trying to return/build a date that is based on 2 other dates from a
table.
>
> For example, the date is equal to the Month of one date and the Year-1 of
> another date (the day is always 01).
>
> How can I build this date?
>
> Any ideas or suggestions would be greatly appreciated.
>
> Thanks!
>
> Ted