need help with calculation, using case

[solarpunk]

Hello,

i was wondering if someone can help me out. Basically i want to date stamp a field when it get change. I have a field call Status so when the that field get change i want to tracke it.

i have a fields

Log = lookup

Log_calc = Current_Modification & "¶" & Log

Current_modification = Status(CurrentFieldName) & DateToText( Status( CurrentDate) )

it work fine but instead of just showing me the date by itself i get this: Status8/17/2005

i just want to track when the field Status when it get change. i am running FM 6 on mac, using panther.

Thanks for the help.

[sbg2]

"Current_modification = Status(CurrentFieldName) & DateToText( Status( CurrentDate) )"

well trying removing Status(CurrentFieldName) from the above calc. You are telling it to add the current fields name to the current date, hence "Status8/17/05".