guanlafe

Discussions

Add rows based on Start and End Date
I have the following table within my output Cust_No Start_Date End_Date Comp_Val Monthly_Val 123 2023-01-01 2023-06-30 1100 55.95 123 2023-07-01 2024-02-05 1100 22.90 As you can see, the months between start_date and end_date for this example, is 13+ months. What I would like to see is a row for each Year_Month between…
Calculate time between two dates during business hours, excluding holidays & Sat/Sun
Need to calculate the elapsed time/minutes between Start Date and End Date, using business hours of 9:00AM to 5:00PM, excluding Saturday/Sunday & holidays. Anyone able to help? either in Magic ETL or Beast Mode.

Add rows based on Start and End Date
I have the following table within my output Cust_No Start_Date End_Date Comp_Val Monthly_Val 123 2023-01-01 2023-06-30 1100 55.95 123 2023-07-01 2024-02-05 1100 22.90 As you can see, the months between start_date and end_date for this example, is 13+ months. What I would like to see is a row for each Year_Month between…
Calculate time between two dates during business hours, excluding holidays & Sat/Sun
Need to calculate the elapsed time/minutes between Start Date and End Date, using business hours of 9:00AM to 5:00PM, excluding Saturday/Sunday & holidays. Anyone able to help? either in Magic ETL or Beast Mode.