Date format

[SatyaPaleti]

Hi Friends,

I am Having a date 6/16/2015  6:00:08 AM

I want to show this date (6/16/2015  6:00:08 AM) as '16-june-2015' How can we do this?

Thank you,

SatyaPaleti

[sasiparupudi1]

=date(date#(SubField('6/16/2015  6:00:08 AM',' ',1),'M/DD/YYYY'),'DD-MMMM-YYYY')

[Gysbert_Wassenaar]

date(floor(date#('6/16/2015  6:00:08 AM','M/D/YYYY  h:mm:ss TT')),'D-MMMM-YYYY')

[robert_mika]

=DATE(Date#(TextBetween ('6/16/2015  6:00:08 AM','',' '),'M/DD/YYYY'),'D-MMMM-YYYY')

[SatyaPaleti]

I am Having Field like this I want to show like following

[sasiparupudi1]

=date(date#([Creation date],'M/DD/YYYY'),'DD-MMM-YYYY')

[Kushal_Chawda]

=date([Creation Date],'DD-MMMM-YYYY')

[#8]

Yes, as Kush said this will work

=Date(date_closed,'DD-MMM-YYYY')

[MarcoWedel]

another one:

Date(DayName(Timestamp#('6/16/2015  6:00:08 AM','M/DD/YYYY  h:mm:ss TT')),'DD-MMMM-YYYY')

regards

Marco

[qlikviewwizard]

Hi SatyaPaleti

Please use this simple script:

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='$#,##0.00;($#,##0.00)';

SET TimeFormat='h:mm:ss TT';

SET DateFormat='DD-MMMM-YYYY';

SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

Table:

LOAD  date(Date) as Date INLINE [

Date

6/16/2015 6:00:08 AM

5/16/2015 6:00:08 AM

4/16/2015 6:00:08 AM

3/16/2015 6:00:08 AM

2/16/2015 6:00:08 AM

1/16/2015 6:00:08 AM

];