Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
=date(date#(SubField('6/16/2015 6:00:08 AM',' ',1),'M/DD/YYYY'),'DD-MMMM-YYYY')
date(floor(date#('6/16/2015 6:00:08 AM','M/D/YYYY h:mm:ss TT')),'D-MMMM-YYYY')
=DATE(Date#(TextBetween ('6/16/2015 6:00:08 AM','',' '),'M/DD/YYYY'),'D-MMMM-YYYY')
I am Having Field like this I want to show like following
=date(date#([Creation date],'M/DD/YYYY'),'DD-MMM-YYYY')
=date([Creation Date],'DD-MMMM-YYYY')
Yes, as Kush said this will work
=Date(date_closed,'DD-MMM-YYYY')
another one:
Date(DayName(Timestamp#('6/16/2015 6:00:08 AM','M/DD/YYYY h:mm:ss TT')),'DD-MMMM-YYYY')
regards
Marco
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
];