you can use substr function to pull some sub string of this.
use like, $b=substr(date.field in$file, 1, 7)
or if you need date or time then us function like day,date,dayof week,month
====== RAD function: substr A RAD function that extracts a substring from a string.
Function substr Format substr(string, beginning position, length) Parameters The following parameters are valid for the substr function: Parameter Data type Description $string String The string being modified. beginning position Number The position in the string where the substring is to begin. length Number The total number of characters you want the substring to contain. The default behavior is to include all remaining characters in the string from the starting position. You can use the length parameter to specify a shorter substr length.
Example $a=substr("Service Manager", 8) $b=substr("Service Manager", 1, 7) After execution, the value of $a is Center and the value of $b is Service.
____________________________________ Assign Kudo, if found post useful and mark it accepted if solves the issue.
When i told about part i mean if field have value "08:00:00" and i whant to get 1/2 и 3/4 of this value - that 04:00:00 and 06:00:00. (multiplying and dividing the value of the field by a specified amount.)
It appears that you can perform a mathmatical operation directly against a duration. From the RAD Debugger:
x $test='08:08:12' 08:08:12 set variable to date/time duration d $test='08:08:12' true verify successful initializtion of variable d type($test) 3 field type is date/time before the calculation >d type($test/2) 3 field type is still date/time after the calculation d ($test/2) 04:04:06 value is 1/2 original duration
If you want to be really careful, you could convert your duration to numeric, divide, then convert back to date/time:
$placeholder=val(duration in $file,1) converts duration in record to numeric equivalent
$placeholder=$placeholder/2 divides numeric equivalent by two
duration in $file=val($placeholder,3) converts result back to date/time and saves result to duration field in record
You could probably even nest it like crazy!
duration in $file=val((val(duration in $file,1)/2),3)
ok. I did use next line in trigger: ... var TemplateBreach_50 = system.functions.val(((system.functions.val(TemplateBreach, 1))/2),3); var TemplateBreach_75 = system.functions.val(((system.functions.val(TemplateBreach, 1))*3/4),3); ...