Date format

[#1]

Hi my date format is as below

date

2016 apr

2016 mar

2016 feb

i want to convert thisinto to the below format

Date

apr-2016

mar-2016

feb-2016

Note  iwant this to be done in a text object

[sunny_talwar]

Try this may be:

LOAD Date(Date#(date, 'YYYY MMM'), 'MMM-YYYY') as Date

[#3]

Hi sunny i want this in a text object

I have loaded the script and got the values

How can i show date as mentioned above in text object

[its_anandrjs]

In a script level try this way by making new field

Load

Lower(Date(date,'MMM-YYYY')) as NewDatefield

From Source;

And in the front end try to create the text object as

=Concat(DISTINCT NewDatefield,' ')

Regards

Anand

[its_anandrjs]

In text object write

=Concat(DISTINCT NewDatefield,' ')

Note:- But why not you use list box for this what is the purpose and reason.

Regards

Anand

[#6]

I want to show

The total no of populatikn and date format as

Above mentioned

[MarcoWedel]

=Right(date,3)&'-'&Left(date,4)

(only returns result for one possible/selected value of date field)