Change date format to mmm dd yyyy

We want to change format from 2020-02-01 to Feb 01 2020
we have imported due date changes, whenever we are trying to update the formatting it doesn’t show up desired result

eazyBI imports previous custom field date values as a comma separated string. While we can transfer one date (from string to date) using a desired formatting it is a bit challenging to apply this for cases when there is several previous dates.

Here is an example formula for this:

CASE WHEN
instr(
  [Measures].[Issue CF Due Date old values], ","
) > 0
THEN
Generate(
    Filter(
      -- get relevant dates from Time dimension
    [Time].CurrentHierarchy.Levels("Day").Members,
    AnyDateInPeriod(
      [Measures].[Issue CF Due Date old values],
      [Time].CurrentHierarchyMember
    )),
  -- apply the new formatting
  Format([Time].CurrentHierarchyMember.StartDate, 'MMM dd yyyy'),
  ",")
ELSE
  Format(DateParse([Measures].[Issue CF Due Date old values] ), 'MMM dd yyyy')
END

The formula above uses Time dimension day members to transform several dates in a new format. It applies simple formatting change for one date value.

Daina / support@eazybi.com

Hello Ramesh,

Can you help me how import duedate-oldvalue in eazybi?
I find below link page, but it works for jira cloud.

Thank’s
Azadeh