URL Reporting - Date Parameter not working

[Former Member]

Hi all,

I am using Crystal Reports Server 2008 and utilizing the URL reporting feature. I have been able to get everything to work with the exception of passing dates/datetimes to the report. According to the documentation (http://devlibrary.businessobjects.com/BusinessObjectsXI/en/en/BOE_SDK/boesdk_dotNet_doc/doc/boesdk_net_doc/html/URLreporting_new13.html#191029) I should be able to specify it as follows:

promptex-mydate="Date(2008,12,23)"

However, when I do this it apparently doesn't parse correctly since it is sending a Null value to my database parameter instead of 12/23/2008. If also tried to put the time at the end of it ("Date(2008,12,23,10,10,10)") but no luck there either.

It's most likely something simple that I'm missing but I'm having the hardest time trying to figure it out. Can someone please show me what I am doing wrong?

Thanks,

Tom

[former_member936117]

Bonjour,

Je n'arrive pas à passer le paramètre date au niveau Crystal report à partir de python, j'ai eu ce message d'erreur

TypeError: must be a pywintypes time object (got datetime.date)

alors qu'aucun obstacle n'a été rencontré lors du passage des autres types de paramètres (entier, chaine de caractère etc...)

Besoin de votre aide SVP

[AnnePetteroe]

Hello, While we're happy that you've come to SAP Community to get an answer to your question, you posted your question as an answer in an old thread.I've converted your answer to a comment, but even so -- posting in older threads is not the best way to get guidance.If you're looking for help, you should ask a new question: https://answers.sap.com/questions/ask.html.Here are some tips to help you craft an effective question for our community: https://community.sap.com/resources/questions-and-answers, https://developers.sap.com/tutorials/community-qa.html, https://groups.community.sap.com/t5/welcome-corner-discussions/advice-from-sap-champions-questions-a... regards,

Anne

[Former Member]

Guess I don't get points for answering the question myself, but oh well. At least it's answered. LOL

[Former Member]

Well, of course I was able to figure it out just AFTER posting...but for anyone else in the future here's an explanation. My database parameter was a DateTime but I was using the "Date(yyyy,mm,dd)" feature instead of the "DateTime(yyyy,MM,dd,hh,mm,ss)" feature. Because of this, the datatypes didn't match and therefore did not work correctly.

SAP/BO: This would be helpful in the documentation for the future as I was unable to find DateTime in there anywhere. I just happened to type it in out of desperation and low-and-behold it worked.