Date format

building semantic layer
1

Quick date format query

I am trying to convert a U.S style date to a British style. Target DB is SQL server. In the universe I am using the convert(datetime,DOB,103) which should render as DD/MM/YYYY but seems to be returning MM/DD/YY.

Any comments appreciated.

juno (BOB member since 2008-06-23)

2

Check this post…

https://bobj-board.org/t/84923

Mak 1 :uk: (BOB member since 2005-01-06)

3

Many thanks I would have been shufflin’ about for hours with that one.

juno (BOB member since 2008-06-23)

4

Yep, most of the common ones are in there - its a great list.

Mak 1 :uk: (BOB member since 2005-01-06)