Greetings Lanticians, members

I created text box called "Input" in a form

Program Editor

Input =@ToDate(Input)   on Form Entry

I get no errors. but when I test adding data in preview

the text field reads 0000/00/00

Q- How come the date does not show up?

Quote:


@todate  function is to convert the other value to date value.  What you want is the date displayed on phone entry.  In Q& A there used to be Initial value in which you could put @date in order to take today's date value in the date field but you cannot use @date in Sesame.

What you want to do is to have the Input data formatted for Date instead text value.  Obviously it is formatted as text in order to display the format yyyy/mm/dd, that is the way it is stored in the database.

In Program Editor

Input =@Date   on Form Entry

I think, this should do it what you want.  I am just amateur and If I am not clear or wrong, a Lantican Member will give guidance.

Bharat

I orginally set up Input as a text box unbound.  Then I  tried to program it  as follows:

Input =@ToDate(Input)

My goal is thatf once a record is added. It stamps a date.

I can try to save this text box as a bound to New date and see what happens.

Thanks,  still working on this.

Dave,

I use this to accomplish the task you explained. It only executes if the record is totally new. My Element is called Dateentered and this is the code snippet that executes on form entry.

// This enters Todays Date if record is new

If @isnew and Dateentered = "" then
{ 
    dateentered = @date

}

Quote:


Dave,

Just a word of caution.

You said on element entry. This means every time you click into the  element input the date will change to that days date.