Date Variables (business days)

[danielnevitt]

Hi,

Is it possible to to set variables showing:

1) Today() minus one business day

2) Today() minus two business days

3) Today() minus three business days

Thanks,

Daniel

[vinieme12 · Accepted solution]

Try

=Firstworkdate(DATE#('12/03/2016','MM/DD/YYYY'),1)

This will minus one day to your date and move to the next business day , adding 1 day to Saturdays date and moving to Friday 2 Dec that is previous business day

=LastWorkDate(DATE#('12/03/2016','MM/DD/YYYY'),1)

This will add one day to your date and move to the next business day , adding 1 day to Saturdays date and moving to Monday 5th Dec that is next business day

[danielnevitt]

Thanks for your help

[danielnevitt]

Hi Vineeth,

Is it possible to use the above in an expression?

I tried the following, however I received an error:

=Sum({<DTLS_PAYMENT_RECEIPT_IND={'R'},ReportDate={FirstWorkDate(DATE#(today(),'DD/MM/YYYY'),1)}>}DTLS_AMOUNT)

Regards,

Daniel

[vinieme12]

Try as below

=Sum({<DTLS_PAYMENT_RECEIPT_IND={'R'}

,ReportDate={"$(=DATE#(FirstWorkDate(today(),1),'DD/MM/YYYY')"}>}DTLS_AMOUNT)

[danielnevitt]

Thanks for the response Vineeth.

Unfortunately that expression does not work.  It would be much appreciated if you could investigate what the issue might be.

Thanks,

Daniel

[vinieme12]

Try evaluating

=Sum({<DTLS_PAYMENT_RECEIPT_IND={'R'}

,ReportDate={"$(=DATE(FirstWorkDate(today(),1),'DD/MM/YYYY'))"}>}DTLS_AMOUNT)