Hi!
1) Excuse me for my english!
2) I must prepare a formula in a field in paradox report that show number "23" if the date of a record (:Tables:comm.Comm_dt_aper) is < "31/12/2010", else shows "24". What can I do to make this?

Thank you very much for all the answers!

[my field] = IIF( (:Tables:comm.Comm_dt_aper) < "31/12/2010", "23" , "24" )

your example, as shown, might not work correctly without DATEVAL() or other similar conversion

Where can I fill the DATEVAL? Before Comm_dt_aper and/or 31/12/2010 doesn't works...

= IIF( (:Tables:comm.Comm_dt_aper) < DATEVAL(31/12/2010), "23" , "24" )

I do not what any of your field types are, I do not know what your variables types are, I do not know what version of paradox you are using, I do not know what your error message is, etc, etc, etc.. my example was just an example to give you ideas.. if you supply much more detail, and post your message on the "paradox community" forum, you can get some great help..

Home - Paradox Community

go to support, then go to newsgroups..