Bengaluru, IN

Welcome to the Bengaluru User Group

Click in the JOIN GROUP button in Home to follow our news and attend our events!

DateTimeDiff() query

MahanteshS
8 - Asteroid

Requirement :- "Remove users with Transfer Dates within 15 business days of the user list create date."

 

My idea:- "(DateTimeDiff([Transaction Dt From],[Inserted Date],'days')) >= 15"

 

Q1) Is above logic is correct?

 

Q2) How to select only 15 business days/ working days ??

2 REPLIES 2
Vijuzy
8 - Asteroid

Your logic is correct, for working days related question follow

 

https://community.alteryx.com/t5/Data-Preparation-Blending/Datetimediff-using-only-weekdays-business...

 

@RodL has already created a macro for it. It might help.

MahanteshS
8 - Asteroid

Thank you vijay