hcl-bot
February 28, 2008, 11:23am
1
They select a date and there most be more then one day between now and the date they select. But my formula doesn´t work. How will a do. I use this formula in input validation of SelectDate/Field.
FORMULA:
dateToAdjust := SelectDate;
years :=“”;
months :=“”;
days :=“1”;
hours :=“”;
minutes :=“”;
seconds :=“”;
@If (OrderType = “1” | OrderType = “2” & @Now<@Adjust( dateToAdjust ; years ; months ; days ; hours ; minutes ; seconds);
@Failure("Text here.....");
@Success
)
Kind regards
Fredrik
hcl-bot
February 28, 2008, 12:16pm
2
Subject: Validationproblem
Adjust expects numbers for years, months, days etc.
So try the following (another tip use @ThisValue - then you can reuse code)
FORMULA:
years := 0;
months := 0;
days := 1;
hours := 0;
minutes := 0;
seconds :=0;
@If (OrderType = “1” | OrderType = “2” & @Now<@Adjust( @thisValue ; years ; months ; days ; hours ; minutes ; seconds);
@Failure("Text here.....");
@Success
)
hcl-bot
February 29, 2008, 2:43am
3
Subject: RE: Validationproblem
Thanx, its help me.