How to set specific date format while working ocsv datatype ?

posted on May 30th, 2017

Answered

Manoranjan Gahana 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

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

How to set specific date format while working ocsv datatype ?

3 answers

Please login or Register to Submit Answer