1 Topic by nitin.ingale08 (edited by nitin.ingale08 2014-11-01 12:54:31)

  • Registered: 2014-10-10
  • Posts: 156

Topic: grid table date format

can we change date & time format in grid?

as grid table taking more space. also i dont what seconds ...

As we define time & Date format in filed. likewise same date & time format why not coming in grid table?

Please See file of Enquiry Followup Software Email to You.

  • Registered: 2014-02-14
  • Posts: 10,294

Re: grid table date format

For formating Date/Time you can use calculated fields

example:

strftime('%d-%m-%Y   %H:%M', Date)

If you need time with AM/PM

strftime('%d-%m-%Y ', Date) ||

CASE
        WHEN CAST(strftime('%H', Date) AS INTEGER) = 12
                THEN strftime('%H:%M', Date) || ' PM'
        WHEN CAST(strftime('%H', Date) AS INTEGER) > 12
                THEN strftime('%H:%M', Date, '-12 Hours') || ' PM'
        ELSE strftime('%H:%M', Date) || ' AM'
END

I sent you project.

Dmitry.