Forum Discussion

rkumar's avatar
rkumar
Icon for Helper III rankHelper III
8 years ago
Solved

Short Date Format(01 Jan 2018)

Hi All, We need to convert date from any format to dd mmm yyyy format eg '2018-03-21' to '21 Mar 2018' and sort it.  Is is possible to do that .   Thank You
Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    8 years ago

    Hi rkumar,

     

    To change format, click Modeling->Format->14 March, 2001(d MMMM,yyyy).

    To sort, right click on the column then click “Sort Ascending” or “Sort Descending”.

     

    Regards,

    Jimmy Tao

rkumar's avatar
rkumar
Icon for Helper III rankHelper III
8 years ago

The date_id column in the above screenshot is from date table (W_Calendar_D) and this tabe has all distinct dates. The duplicates are in Product table. somehow while sorting its not removing data (As the message says, There cant be more than one value in Date_id for the same value in ShortMonthDate .) 

"Do we need distinct values in both tables "

vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
8 years ago

rkumar what i am saying is you should be using your date table values not the other table to do the sort by

 

effectively you should have a numerical date in your transaction table, that should link  (relationship) to a numerical date in your date table in your date table you should have the short date time, you then sort the short date time by the the date in the date table.  The short date time should not be in the transaction table. not if you want to use it in this context, make sense?