formula

Dhodie · October 15th, 2003, 05:39 AM

Right click on the Formula then click on Format Field.
Format Editor window will be shown and from the Date/Time Tab
choose your desired date format. It is assumed that your formula
field is a Date/Time type.

-Dhodie

winnie1778 · October 15th, 2003, 05:50 AM

I know it can be done if the field is database field.
But for formula field, it doesn't provide the Date/ Time format.

ahussain · October 15th, 2003, 11:41 AM

Try this:

If IsNull({WOS.Date_Sum}) Then
"-"
Else
ToText({WOS.Date_Sum}, 'dd/MM/yyyy')

Result value should be = eg. 18/08/2001

HTH
Akhtar

winnie1778 · October 15th, 2003, 07:44 PM

Hi Akhtar,

Thanks.
Have a blessed day.

Rgds,

winnie1778 · October 16th, 2003, 03:25 AM

Hi! I would like to do case statement in the formula.
How to use the "select case : default: "?

Case "A"
formula = "CaseA"

Case "B"
formula = "CaseB"

Case "C"
formula = "CaseC"

.
.
.
etc...

Please Help.

Thanks