CODEWITHSUNDEEP
javascripthtmlvue.jsnuxt.jsvuetify.js
Kavin404
Kavin404

Reputation: 1029

How to format Vuetify data table date column?

I have a simple data table using Vuetify data table. One of the column is a createdOn (date time), I want to format it. How can I do it ?

This is what i get now:

This is what i get now

<template>
   <v-layout>
      <v-data-table :headers="headers" :items="logs">
      </v-data-table>
   <v-layout>
</template>
<script>
      headers: [
        { text: "Time", value: "createdOn", dataType: "Date" },
        { text: "Event Source", value: "eventSourceName" },
        { text: "Event Details", value: "eventDetails" },
        { text: "User", value: "user" }
      ],
      items: [],
</script>

Upvotes: 43

Views: 51903

Answers (6)

ryanhex53
ryanhex53

Reputation: 727

You can use the date composable provided in Vuetify version 3.4.0+

<template>
  <v-data-table :headers="headers" :items="logs">
     <template #item.createdOn="{ item }">
        {{ date.format(item.createdOn, 'fullDateTime24h') }}
     </template>
  </v-data-table>
</template>

<script setup>
import { useDate } from 'vuetify';
const date = useDate();
</script>

Upvotes: 0

SneakyLenny
SneakyLenny

Reputation: 553

I found out a way to format cell values using dynamic slot names and a function in the header object:

In the <v-data-table> I did:

<template v-for="header in headers.filter((header) => header.hasOwnProperty('formatter'))" v-slot:[`item.${header.value}`]="{ header, value }">
  {{ header.formatter(value) }}
</template>

and in the vue data property I did:

headers: [
  // ...
  { text: 'Value for example', value: '10000', formatter: formatCurrency },
  // ...
]

And finally in the methods prop I did:

formatCurrency (value) {
  return "$ " + (value / 100).toFixed(2);
}

Here's a sandbox to see it in action: https://codesandbox.io/s/vuetify-datatable-value-formatter-jdtxj?file=/src/App.vue

EDIT:

In this specific case you could use momentjs or javascript's Date(). I've added a momentjs example to the codesandbox.

Upvotes: 23

Alec Gerona
Alec Gerona

Reputation: 2897

If you want an even simpler solution or at least one where you can format other columns as well:

<v-data-table :headers="headers" :items="logs">
  <template v-slot:body="{ items }">
    <tbody>
      <tr v-for="item in items" :key="logs.id">
        <td> {{ new Date(item.createdOn).toLocaleString() }} </td>
        ...
      </tr>
    </tbody>
  </template>
</v-data-table>

The trick is using the body slot of v-data-table. More information here.

Upvotes: 1

Okan Sari
Okan Sari

Reputation: 1

In datatable component Datatable.vue

<template v-for="slot in slots" v-slot:[`item.${slot.slotName}`]="{ item }">
  <slot :name="slot.slotName" :variable="item"></slot>
</template>

export default {
props:
slots:{
  type:Array,
  default:null
},

and parent component

<Datatable
 :headers="headers"
  :items="stokhareketleri"
  :title="title"
  :slots="slots">
<template v-slot:column_name="{ variable }">
  <v-chip
        color="green"
        dark
      >
      {{variable.column_name}}
      </v-chip>
</template>
  </Datatable>


data () {
      return {
        slots:[{ 
          Id: 1, slotName: 'column_name'
          }],

Upvotes: 0

jcons
jcons

Reputation: 1

I have also used global filter with v-slot:

<v-data-table :headers="headers" :items="logs">
  <template v-slot:item.createdOn="{ item }">
    <span>{{ item.createdOn | myGlobalDateFilter }}</span>
  </template>
</v-data-table>

Upvotes: 0

Boussadjra Brahim
Boussadjra Brahim

Reputation: 1

You should use a custom row cell :

<v-data-table :headers="headers" :items="logs">
  <template v-slot:item.createdOn="{ item }">
    <span>{{ new Date(item.createdOn).toLocaleString() }}</span>
  </template>
</v-data-table>

Upvotes: 81

Related Questions