>Hi,
>
>I am actually using a field called target_date which displays in the format month/day/year and then I used a function cmonth(target_date) as display_month
>which displays the month string. For some reason when we build the report, the
>target_date field gets affected and displays in the format day/month/year. Any suggestions?
>
>
>
>Thanks

Sounds like something in the environment is changing the SET DATE...setting. Since this is scoped to the data session, it might not be apparent elsewheres.