DatetimeParse how to skip weekend days?

Joker_Hazard

Hi all.

I have a formula that sum(adds) +2 days into a basic date column for later use. The problem is, it's summing with weekend days. For example;

3th of June -> Friday.

What should be done:

Formula adds two days desconsidering weekends, in this case the result would be 7th of June.

What is happening:

Formula is giving the result of 5th of June.

DateTimeFormat(DateTimeAdd(DateTimeParse([DATA_MOVIMENTO],"%Y-%m-%d"),+2,"days"),"%Y-%m-%d")

DATA_MOVIMENTO = 3th of June btw as 2022-06-03.

How to avoid that?

Thanks

IraWatt

Hey @Joker_Hazard,

Here is one solution to this problem:

This formula:

IF DateTimeFormat(DateTimeAdd([DATA_MOVIMENTO],1,"days"),"%A") = "Saturday" 
THEN 
DateTimeAdd([DATA_MOVIMENTO],4,"days")
ELSEIF 
DateTimeFormat(DateTimeAdd([DATA_MOVIMENTO],1,"days"),"%A") = "Sunday" 
THEN 
DateTimeAdd([DATA_MOVIMENTO],3,"days")
ELSE
DateTimeAdd([DATA_MOVIMENTO],2,"days")
ENDIF

Checks the next day after the given date if its Saturday then add 4 days if Sunday add 3 else just add 2 days.

Any questions or issues please ask
HTH!
Ira

Workflow0506.yxmd