expression

master_student · ‎2016-08-01

Hi everyone,

could you explain to me this expression please :

Age =dayStart(Today()) - dayStart([Date création] )

I need to get the working days between date creation and today, with excluding the days on vHol variable. here's my formula :

(NetWorkDays([ROW_ADDED_DTTM], [ROW_LASTMANT_DTTM]-1, $(vHol))

Is my expression correcte?

Thanks

vinieme12 · ‎2016-08-01

is your expression not working?

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

Anil_Babu_Samineni · ‎2016-08-01

While you are asking about expression, Try to share whole expression with out Variables?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

jonathandienst · ‎2016-08-01

Looks OK, assuming that the the 2 fields are QV date values and that vHol is defined correctly. vHol should look like

Set vHol = '2016/01/01', '2016/05/01';

Test the expression without vHol; and if the number is correct, then add vHol and test again.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

Related Topics