Forum Discussion

LyonsBI_BRL's avatar
LyonsBI_BRL
Icon for Helper III rankHelper 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
Icon for Super User rankSuper 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
    Icon for Helper III rankHelper III
    4 years ago

    That did it thank you!