Page 2 of 2

Re: Picking current date but changing when viewing the case

Posted: June 16th, 2017, 2:16 pm
by josh
For numeric items you can check for blank by comparing to notappl. If you are in system controlled mode you need to use visualvalue since you are in preproc so the field has not been completed yet.
PROC DATE
preproc
if visualvalue($) = notappl then
    $=
edit("99/99/99",sysdate("DDMMYY"));
endif;

Re: Picking current date but changing when viewing the case

Posted: August 24th, 2020, 4:44 am
by tegegne mulu
how I can use the system date format different from current date

Re: Picking current date but changing when viewing the case

Posted: August 24th, 2020, 9:35 am
by Gregory Martin
The sysdate function returns the current date. If you have different dates that you want to use as a single number, then you can construct them yourself using math. For example, if I wanted February 1, 2020 in YYYYMMDD format I could write:
( ( 2020 * 10000 ) + 2 ) * 10 + 1