Morning all users and administrators.
I'm working to design a new data entry and I want the date and time be generated by the system. So I used the functions sysdate() and systime().
But the matter is in the fact that time/date update each time I have to move on again time/date question. I would like it keeps the values which appear the first time I moved on those questions.
Please, how should I do that???
Thanks for your answers!!!
SysTime & SysDate functions
-
- Posts: 1805
- Joined: December 5th, 2011, 11:27 pm
- Location: Washington, DC
Re: SysTime & SysDate functions
You can do something like this:
PROC FIRST_TIME
preproc
if visualvalue(FIRST_TIME) = notappl then
FIRST_TIME = systime();
endif;
preproc
if visualvalue(FIRST_TIME) = notappl then
FIRST_TIME = systime();
endif;
-
- Posts: 16
- Joined: September 30th, 2016, 12:48 pm
Re: SysTime & SysDate functions
Thanks very much Gregory
It works now as I wanted
It works now as I wanted
Re: SysTime & SysDate functions
Dear Josh
I have similar case for the GPS. I want to keep the GPS i obtained in 30 minutes ago because enumerators move around. When they move around they do try to review the interviews may be they captured wrong (street name or village), on the other hand the GPS changes and also we lose the actual location of the study.
How to avoid this problem as the one proposed in system date above
I have similar case for the GPS. I want to keep the GPS i obtained in 30 minutes ago because enumerators move around. When they move around they do try to review the interviews may be they captured wrong (street name or village), on the other hand the GPS changes and also we lose the actual location of the study.
How to avoid this problem as the one proposed in system date above
Re: SysTime & SysDate functions
The approach for GPS would be exactly the same as for the date. Instead of FIRST_TIME use the variables you use to store latitude and longitude.
Re: SysTime & SysDate functions
Dear Josh, Thanks works very well
Re: SysTime & SysDate functions
Hi everyone !
I have the same problem. I tried this proposal but it doesn't work because I put the item "time" in alpha. This is because I want to use the function ($=edit("99:99",systime()).
Can you help me please ?
I have the same problem. I tried this proposal but it doesn't work because I put the item "time" in alpha. This is because I want to use the function ($=edit("99:99",systime()).
Can you help me please ?
-
- Posts: 1805
- Joined: December 5th, 2011, 11:27 pm
- Location: Washington, DC
Re: SysTime & SysDate functions
With alpha fields you don't have to use visualvalue because you always get the "visual value," so you can just write:
PROC FIELD
preproc
if $ = "" then
$ = edit("99:99",systime());
endif;
preproc
if $ = "" then
$ = edit("99:99",systime());
endif;