Date import from config file

[Sucess_for_Everyone]

Need some help on import data from Config file. While I am trying to import formula from config it is under double quotation or back Slash where formula is not executing. Example

Under config file
Date: now.adddays.today(-7) (“dd/mm/yyyy”)

Output in workflow is

“now.adddays.today(-7) (”\dd/mm/yyyy")"

Tried replace and remove but nothing work… any leads will be appreciated

[lrtetala (Lakshman Reddy)]

Hi @Sucess_for_Everyone

You syntax is also wrong try this

Now.AddDays(-7).ToString("dd/MM/yyyy")

Can you try like below

Config("Date").ToString.Replace(Config("Date").ToString,Now.AddDays(-7).ToString("dd/MM/yyyy"))

Regards,

[Yoichi]

Hi,

Do you want to run expression which is written in config file?
If so, basically it’s difficult.

For simple expression, the following post might help you.

Is it possible to create a code where it behaves like a scientific calculator?

Hi, Unfortunately, Vb or C# doesn’t have a function like eval(), we need to approach by other ways. ● DataTable.Compute method strExpression = "((10-5)*(2+2))*5" dt = New DataTable() Then dt.Compute(strExpression, "").ToString ● Inject JS script activity strExpression = "((10-5)*(2+2))*5" Inject JS Script activity Indicate an element in any browser. Input Parameter : strExpression ScriptCode "function(e,v) { return eval(v); }" ScriptOutput : strResult ●Use 3rd party library. Per…

Regards,

[Anil_G (Anil Gorthi)]

@Sucess_for_Everyone

Welcome to the community

Instead of full expression in the config…you can give the difference of days alone in config like -7 and then use that in the code to get the required date…so in config store on -7 and in the code use

Now.AddDays(Cint(in_Config("Daysvalue").Tosstring)).ToString("dd/MM/yyyy")

Cheers