asked on May 30, 2017
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
⋅ 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 ?
⋅ May 31, 2017
And also i want to work with quarter dateformat like QQ,QQ-yyyy etc.
⋅ 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
