Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this may be:
LOAD Date(Date#(date, 'YYYY MMM'), 'MMM-YYYY') as Date
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
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
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
I want to show
The total no of populatikn and date format as
Above mentioned
=Right(date,3)&'-'&Left(date,4)
(only returns result for one possible/selected value of date field)