Converting Service Period to Days

Comments

• Options

  randrews Member Posts: 135

  2005-02-09

  In the TextBox put this code on trigger

  OnAfterInput(VAR Text : Text[1024];)
  date1:=WORKDATE;//any date
  date2 := CALCDATE(Text,date1);
  Text := FORMAT(date2-date1)+'D';
  

  
  It works. I tried

  0
• Options

  Trevor_Norcross Member Posts: 29

  2005-02-09

  OK that does work, thank you... now what if I wanted to put that text variable back into the table as a dateformula... how can I convert from a text variable to a dateformula?

  Trevor Norcross
  SharePoint Implementation and Development
  Network Administration
  Mirifex Systems

  0
• Options

  randrews Member Posts: 135

  2005-02-09

  ???
  Text is variable VarRef:

  OnAfterInput(VAR Text : Text[1024];)
  

  So you put that text variable back in table

  Text := FORMAT(date2-date1)+'D';
  

  
  But how to convert text into dateformula at triger OnValidate, for example, I don't know.
  
  May be somebody else have idea?

  0
• Options

  Trevor_Norcross Member Posts: 29

  2005-02-09

  I think you understand what I'm trying to do now... using your code, I now have a text variable with some value such as '10D' and I want to change a DateFormula field in a table to have this text variable's value.

  Trevor Norcross
  SharePoint Implementation and Development
  Network Administration
  Mirifex Systems

  0
• Options

  jreynolds Member Posts: 175

  2005-02-09

  EVALUATE(DateFormula,Text)

  0