Skip to Content
avatar image
Former Member

Information Design Tool parameters setting

Dear All,

I would like to ask some help in setting the Information Design Tool parameters. We can give the prompt value as fix value (constant option) or also with formula Constant setting:


Szövegközi kép 2

This works perferctly.

Szövegközi kép 4
My question is that how can I resolve it with formula? How can I get this two values with formula?

The two formulas are:

Formula1: ToNumber(FormatDate(Date(Year(CurrentDate());MonthNumberOfYear(CurrentDate());1);"YYYYMM");"######") Formula2: ToNumber(FormatDate(RelativeDate(Date(Year(CurrentDate());MonthNumberOfYear(CurrentDate());1);-1;MonthPeriod);"YYYYMM");"######")

Szövegközi kép 5

Thank you in advance,
Regards, Csaba

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 06 at 08:46 PM

    Hi Csaba,

    In the img-1, please use the Formula option (instead of Constant) and paste the below formula in there

    ToNumber(FormatDate(Date(Year(CurrentDate());MonthNumberOfYear(CurrentDate());1);"YYYYMM");"######")    OR   ToNumber(FormatDate(RelativeDate(Date(Year(CurrentDate());MonthNumberOfYear(CurrentDate());1);-1;MonthPeriod);"YYYYMM");"######")

    Try that and let us know.

    Thanks,
    Mahboob Mohammed

    Add comment
    10|10000 characters needed characters exceeded