topic Re: Getting date as timestamp by using YearStart() in QlikView

Getting date as timestamp by using YearStart()

mokitsu61 — Thu, 10 May 2018 05:54:44 GMT

Hi,

I'm trying to get first date of year as Timestamp.

YearStart() function return Date as text, and I can't find converting that value as Timestamp.

LET $value = YearStart('10-10-2018'); // Returns '01-01-2018', But I need a value as Timestamp.

Does any one know how to convert Date value which was returned from YearStart() to value in Timestamp?

Thanks.

sunny_talwar — Thu, 10 May 2018 15:34:46 GMT

May be this

LET $value = TimeStamp(YearStart('10-10-2018'));

LET $value = TimeStamp(YearStart('10-10-2018'), 'MM/DD/YYYY hh:mm:ss TT');

mokitsu61 — Fri, 11 May 2018 01:13:37 GMT

Hi,

It's fixed by following.

LET varDateMin = Num(YearStart($(DateValue))));

Thanks.