Expression Editor

Séverine LE ROCH

Hello,
I have seen in documentation in the website of coresuite that there is an expression editor in Coresuite which permit us to use functions as "round"...
But I don't know where I can find this function in the coresuite designer.
Could you tell me how to use this function please?
Thank you for your help
Best regards
Séverine

Philipp Knecht

Hi Séverine

In the script editor just type Round(MyValue,2)
I'm not aware of an expression editor so maybe i just get you wrong.


hth

Séverine LE ROCH

Thank you for your help, the function "Round" is ok.
But can I use functions of date like "DateDiff" or "Dateadd" in Coresuite?
I want notably to compare two dates.
Thank you
Séverine

Philipp Knecht

Hi again

You can use all .NET Functions.
The one for Dates you can list by typing

System.DateTime. 

hth

Séverine LE ROCH

Hi
I'm sorry but I don't find the solution with VB.NET.
Indeed, I want to know how many days separate the LD.Par.ToDate and the AdvancedDataband1.Date.
Someone can it tell me what's function to do that , please?
Thank you very much
Séverine

Philipp Knecht

Hi Séverine

CType(LD.ParamDateTime(GetData("LD.Par.ToDate")) -  CType(Document("DocDate"),System.DateTime),System.TimeSpan).Days

Will work

hth

Séverine LE ROCH

Hi again!
Thank you very much, it works.
Séverine