Options

How to put Empty record in the DateFormula field???

kishi_gkishi_g Member Posts: 162
Hi,
I created one table with one datatype as dateformula field. that field contains some data like 1m,2m,1d etc..

Now i created one codeunit for empty that field. How can i replace the data to empty. how can i assign???


Thanks & Regards,
kishore...

Comments

  • Options
    BBlueBBlue Member Posts: 90
    Try this in your codeunit:
    IF TargetTable.FINDFIRST THEN 
      REPEAT
        CLEAR(TargetTable."Date Formula Field");
        TargetTable.MODIFY;
      UNTIL TargetTable.NEXT = 0;
    
    //Bogdan
  • Options
    tinoruijstinoruijs Member Posts: 1,226
    DateTimeField := 0dt;

    Tino Ruijs
    Microsoft Dynamics NAV specialist
  • Options
    kishi_gkishi_g Member Posts: 162
    hi,
    Thanks for ur replies. By using CLEAR function it is working fine.



    Thanks & Regards,
    Kishore...
Sign In or Register to comment.