Error calculating input for field 'myField': wrong number of arguments (given 1, expected 0)

[rpatrick_]

Error calculating input for field 'myField': wrong number of arguments (given 1, expected 0)

I need help figuring out what this error means--why does it expect 0 arguments? How can I fix this? 

This is the formula that I have mapping to the field: [DATAPILL]&.to_date(format:"MM/DD/YYYY")

Please let me know if any additional info is needed. Any guidance is appreciated, thank you!

[rajeshjanapati]

Hi @rpatrick_,

your pill may be "now" or "today", which does not return a datetime input as a user-defined string by default, so  you need to add "strf" formula to make it user-defined string, because of that, it is throwing an error. Please check the below attached image and try it out once, if you face any error again, please do posted here.

Thanks & Regards,

J Rajesh Kumar.

[shivakumara]

Hi @rpatrick_ ,

After reviewing the requirement, it appears you are passing dateTime or date as input, which is causing the error:
Error calculating input for field 'myField': wrong number of arguments (given 1, expected 0)
This happens when using the to_date formula, which returns the format YYYY-MM-DD (Required response).

If you are passing a date or dateTime value to to_date, try converting it to a string first. (A sample example is provided below.)

Thanks and Regards,
Shivakumara K A