Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Invoke Custom Function

Hi   I'm trying to use the 'Invoke Custom Function' to populate a new column in a query.  The function requires a date parameter to be passed and a financial period is returned.   I've imported t...
Need Help
  • AlB's avatar
    AlB
    5 years ago

    Hi Anonymous 

    It looks like your Period column is of type date and needs to be converted to datetime, which is the type the function expects

    Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

    Contact me privately for support with any larger-scale BI needs, tutoring, etc.

    Cheers 

     

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi AlB 

 

Thanks for the response but the value being passed is DateTime and the result (Period) is Int. 

 

I'm still struggling to resolve this, any ideas?

 

Regards 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    I found the solution.  The parameter needs to be DateTime and not just Date.