topic Date format in QlikView

Date format

chematos — Thu, 17 May 2012 19:13:39 GMT

Hi,

I´m trying this in the load script to create a field Date type, but trying many ways, it always stays like Timestamp.

Date(Floor(MonthEnd(MakeDate(Left(PERIODO,4),Right(PERIODO,2),'01')))) ---->TimeStamp

MonthEnd(MakeDate(Left(PERIODO,4),Right(PERIODO,2),'01')) ---->TimeStamp

If I do MonthEnd(MakeDate(Left(PERIODO,4),Right(PERIODO,2),'01')) as EndDate in TABLE1, returns to me a timestamp,

but after that I do Date(Floor(EndDate)) and I get a date field. Why if I apply those functions like my first choice it doesn´t work??

Thnak`s for any help.

Chema.

Date format

Jason_Michaelides — Thu, 17 May 2012 20:31:24 GMT

Try wrapping in Date# before the Date(), so Date(Date#(blah blah blah),'DD/MM/YYYY')

Date format

chematos — Thu, 17 May 2012 20:42:34 GMT

Hi Jason,

Thank you, it´s working. But I have a question about this because I´ve tried to do this with two different fields that I have also in my master calendar.

MasterCalendar: I have a date field that is %Date and a timestamp field that is [Month Year], so if I try the previous sentence and I name that as %Date, then I get a date field, but if I name as [Month Year], I get a timestamp. That´s because of my types of data in my Master Calendar and QlikView force to be that fields the same type ??

Regards

Date format

Jason_Michaelides — Thu, 17 May 2012 21:14:12 GMT

That would seem likely. If %Date is already defined as a Date field then it would probably make all future additions to that field the same if possible.