topic Re: Change date format in QlikView

Change date format

Mon, 22 Sep 2014 17:52:39 GMT

Hi Guys

How can u separate time in a date field table and also i need to separate months and year individual

Example : Now It's like 01/01/2014 , I want to change to Jan/2014.

Anonymous — Mon, 22 Sep 2014 19:05:09 GMT

Date(YourDateTime) will return date

Time(YourDateTime) will return time

Date(Today(),'MMM/YYYY') will return Month\Year format

MichaelTerenzi — Mon, 22 Sep 2014 20:36:35 GMT

Now It's like 01/01/2014 , I want to change to Jan/2014. -----

For the above request, something like this will work for the date formatting:

MMM/YYYY h:mm:ss[.fff] TT

Mon, 22 Sep 2014 21:14:48 GMT

format pattern: mmm/yyyy

maxgro — Mon, 22 Sep 2014 22:10:53 GMT

floor(datatimefield) is your date part, example 41904

date(floor(datatimefield)) is your date part formatted as a date

frac(datatimefield) is the time part from 0 to 1

time(frac(datatimefield)) is the time part formatted

Mon, 22 Sep 2014 22:17:50 GMT

Hi Prakash,

Just try like the below code

=Date( Makedate( right(fieldvalue,4), Mid(fieldvalue,4,2) ) , 'MMM/YYYY')

hope it helps!!

Kiru

Tue, 23 Sep 2014 04:33:59 GMT

Hi guys,

thanks u for ur support

Tue, 23 Sep 2014 04:45:24 GMT

try this

DATE(date#(left(Date,19),'DD/MM/YYYY hh:mm:ss'),'MMM/YYYY') AS NEWDATE