Skip to Content
0
Former Member
Sep 10, 2013 at 06:29 PM

Re: ToDate() function not working

25 Views

Hi,

In my current problem date is actually stored without timestamp (in Teradata database), but when I use it in report prompt, it adds the timestamp (12:00:00 AM) by default, and my ToDate function on UserResponse to prompt is resulting in #ERROR. Here is the description of the issue

Date in Database:

12/7/2013

12/14/2013

9/21/2013

Prompt values (Date Object):

12/7/2013 12:00:00 AM

12/14/2013 12:00:00 AM

9/21/2013 12:00:00 AM

In report I am trying to use this formula & it is resulting in #ERROR

=ToDate(UserResponse([DP1];"Week Ending Date (Start):");"MM/dd/yyyy")

Even I tried the one below, but same #ERROR

=ToDate(UserResponse([Selection].[Shipment Quantity in UOM];"Week Ending Date (Start):");"MM/dd/yyyy hh:mm:ss AM/PM")

I am just trying to display the date part in report. Please let me know how this format need to be given to get that date part.

Thanks,

CK

Message was edited by: Simone Caneparo branched to a new thread so it gets more attention