Date Format

building semantic layer
1

Hi,

In IDT 4.X how to set the default date to dd/mm/yyyy format.
currently the input date is in American format.

checked the sql server database dates and in UDT have it in dd/mm/yyyy format.

Thanks,
Arul

Arulmozhi (BOB member since 2006-06-05)

2

Have a look at this post.

charlie :us: (BOB member since 2002-08-20)

3

Hi Charlie,

Thanks for the reply. But this has to be done at object level for every single date object.

I have noticed that when you run the query in webi it is in the British format and only when you run it through query view in IDT it is in the American format.

Thanks,
Arul

Arulmozhi (BOB member since 2006-06-05)

4

Did you try manipulating the date display format in IDT? Click on object, Advanced, Display, Edit Display Format?

charlie :us: (BOB member since 2002-08-20)