Calculation of field of a group at script level!

[#1]

Hi

Following calculation in done for one of the field in group in front end. As the performance I would like to do that in the script level. Could you please help me out how to do the same?

=date(trim(if(date >= '$(vMinDate)' and date < '$(vMaxDate)',date)),'DD/MM/YYYY')

[Miguel_Angel_Baeyens]

Hello,

I assume that you want to format a field in case of this date fills the condition, but otherwise?

I assume as well that those variables exist in the script, if that's the case, the same eyntax you used above my be used as a new field

date(trim(if(date >= '$(vMinDate)' and date < '$(vMaxDate)',date)),'DD/MM/YYYY') AS FormattedDateField

Hope that helps.