mark thanks for your help. i forgot to indicate that i'm using remote views. i guess the to_char command is an oracle command. i'll try more stuff out.