CSPro Users Forum

Dear all,

I have used the following logic to pick the current date for interview date automatically

onfocus
$=edit("99/99/99",sysdate("DDMMYY"));

Then problem is that when viewing the record or modifying on a different day, the date changes to that day's date. How can I fix this?

Regards

Dear Tweg;

Please use this code:

If demode()=1 then

$=edit("99/99/99",sysdate("DDMMYY"));

else
endif;



a.

Dear Arshad,
Thanks for your reply it worked.

Regards

It doesn't work to me.

Yours,
Kyaw Thet

Dear Arshard,

What wrong to me? This logic not working.
How to do that?

PROC DATE
onfocus
iF DATE=edit("99/99/9999",sysdate("DD/MM/YYYY"));
else
endif;


Yours,
Kyaw Thet
Myanmar

another way to code is :


PROC DATE
onfocus
if demode ()= 1 then
DATE=edit("99/99/9999",sysdate("DD/MM/YYYY"));
endif;

I am wondering why you are using the on focus, instead of Preproc,

As others have mentioned, this should be done in the preproc, not in the onfocus. The general rule is that anything that has to do with setting the value of the field is done in the preproc and anything that has to do with setting the question text and/or value set is done in onfocus.

Another alternative is to use check if the field is already filled in rather than using demode:
The difference is that this will only set the field value once so even if you have a partially saved case and you return to the field while still in add mode the value will not change.

Dear all,

preproc
if demode ()= 1 then
DATE=edit("99/99/9999",sysdate("DD/MM/YYYY"));
endif;

I have to change the numeric to alpha (Date).

Thanks You for the guide & help.

Kyaw Thet
Myanmar

Yes. Edit returns an alphanumeric. If you want to store your date numeric then don't use edit:

Hi

But how do I restrict it from changing if it has been entered It's numeric not Alphanumeric
Thanks