DATE ISSUE

[sagaraperera]

Dear all

how to make  " 'MMM YYYY  as TRANS_DATE,"  using the script given below

my Script

    BCOD,

    MONTH,

    YEAR,

    MONTH2,

    CLA_CODE,

    MONM,

    GROSS_PREMIUM,

I previously used the script,  Date(MONTH,'MMM YYYY') as TRANS_DATE.but the "TRANS_DATE" has not organized properly.

looking forward to a favorable reply.

SAGARA

[MK_QSL]

Date (MonthStart (TRANS_DATE),'MMM YYYY') as TRANS_DATE

[#3]

Try this one,

Text(Date(Today(),'MMM YYYY')) as Trans_date

[padmanabhan_ram]

Hi Sagara,

Please try using the below code in the script while loading the dashboard.

Date#(FieldName,'MMM\YYYY') as FieldName

or

Date(FieldName,'MMM\YYYY') as FieldName

or

Date#(Date(FieldName,'MMM\YYYY'),'MMM\YYYY') as FieldName

Try the above codes one by one, check which one works for your format.

Regards,

Padmanabhan

[jagan]

Hi,

Try like this

LOAD

*,

MakeDate(YEAR, MONTH) AS TRANS_DATE

FROM DataSource;

Regards,

Jagan.

[gautik92]

Try this in Dimension Tab

=Date(TransactionDate,'MMM-YYYY')

[Kushal_Chawda]

Use monthname(FiledName) as  TRANS_DATE