Forum Discussion

LyonsBI_BRL's avatar
LyonsBI_BRL
Helper III
4 years ago
Solved

Cannot convert value #datetime to Date

I'm attempting to calculate the number of working days for each Employee, however I'm running into an issue when attempting to calculate it.  Using the supplied function below, I use this to calcu...
Need Help
  • Fowmy's avatar
    Fowmy
    4 years ago

    LyonsBI_BRL 
     The Function NWD asks for Date, not Date/Time value. Before invoking the function, Under Transform Tab, Date > Click on Date Only to convert to Date

     

Fowmy's avatar
Fowmy
Super User
4 years ago

LyonsBI_BRL 
 The Function NWD asks for Date, not Date/Time value. Before invoking the function, Under Transform Tab, Date > Click on Date Only to convert to Date

 

LyonsBI_BRL's avatar
LyonsBI_BRL
Helper III
4 years ago

That did it thank you!