Deleting field data of type Time in all records

lagersjef

Hi is there any easy way of writing a codeunit doing this in a table?

I have tried writing a loop that sets the value of '' or 0 for all instance, but that is not allowed since those values are of type Text or Integer, while the field only allows type Time. How can I delete/empty the value of a field with the type time?

Thanks for any help!

Marije_Brummel

Use

Time := 0T

lagersjef

thanks you're right!

SIH.MODIFYALL(SIH."Posting Time", 0T);

Luc_VanDyck

Maybe you can add "[SOLVED]" to your original Topic Subject, so others now this topic has a solution? See also Suggestion: Use [SOLVED] in Topic Title

lagersjef

This issue has been solved