Date format in IDT
I have an universe based on Teradata. I created a filter in IDT and it's like this :
@Select(Sales\Calendar Day) = @Prompt('Date:','D',,Mono,)
When I use this filter and execute a test query in IDT, the date format is shown different in these 2:
Enter a value : 10.Feb.2015
Date : 10.Feb .2015 00:00:00
I formatted the Calendar Day dimension and I can see it as 'mm/dd/yyyy' in the report result. That's fine.
However, I want to do the same for the prompt screen in IDT too. How can I do this?
The requirement is, I use the same filter for SAP Lumira and it does not provide a calendar component for date selection.
So, the format of date to pass to universe is not clear.