Modify date format // Create column with working days

[LucienF38]

Hello everyone,

Firts of all, please pardon me for my approximative english 😉

I have 2 issues concerning a date :

1) The dates are downloaded from an SQL server. They are in the following format "20190711" (here, for July the 11th of 2019" and I would like to change it into a common form such as 11/07/2019. I tried with "column form example" and it doesn't work. How can I do this ?

2) After resolving the first issue i'd like to create a column based on the data of 2 others : Purchase Order Date and Entry Date which represent respectively the date at which we received the order and the date on which we entered this order in our system. I would like to write "OK" if the entry has been done within 2 working days and "NON OK" if the entry has been done in more than 2 days. The issue is the non working days (saturday and sunday). How can i resolve these problems ? 

Thanks for helping 🙂

[tex628 · Accepted solution]

1.) 

Column = LEFT(Table2[Column1] , 4 ) & "-" & RIGHT(LEFT(Table2[Column1] , 6),2) & "-" & RIGHT(Table2[Column1] , 2)

2.) 
Calculatieng the difference between two dates where you exclude weekends is abit more complicated. Start by creating a calendartable and using the weekday() syntax there to indentify which days that are weekends.