Menu
Download Free Trial

How to set specific date format while working ocsv datatype ?

I want to support the following date format.
dd-MM-yyyy
dd-MMM-yyyy
dd.MM.yyyy
dd/MM/yyyy
MM/dd/yyyy
MM/dd/yy
dd-MMM-yy
dd.MMM.yyyy
dd/MMM/yyyy
MMMM dd yyyy
yyyy-MM-dd
MM.dd.yy
MM.dd.yyyy
dd.MMM.yy
dd MMMM yyyy
dddd MMMM dd yyyy
yyyy
MMM
MM/dd
MM.dd
dd-MM
dd.MM
dd/MM
dd.MMM
dd-MMM
dd/MMM
QQ
QQ-yyyy

3 answers

Public
Manoranjan Gahana May 31, 2017

Suppose i have two date type column like order_date,delivered_date . I want to display order_date data with date format as “yyyy” & delivered_date data with date format as “dd/MMM”.How can i achieve this ?
 
 

Public
Manoranjan Gahana May 31, 2017

And also i want to work with quarter dateformat like QQ,QQ-yyyy etc.

Public
Tanya Gryshko Flexmonster May 31, 2017

Hello Manoranjan,
Thank you for writing. Usually, datePattern property is used to set date formatting. However, only one datePattern can be defined for one report. To display different dates with different formats we suggest using customizeCell() method. Please have a look at the example on JSFiddle. We would be grateful for your feedback.
Regards,
Tanya

Please login or Register to Submit Answer