Compare Date Formats

[#1]

Hi guys,

I extracted datas from my oracle database. These datas are in date format, so they look very similar to timestamp format.

So how I can compare them in QlikView? I only want to count the datas which are smaller than system time. My try looks like this:

=count({$<[HK_NAME_KURZ]={'BUDSTART'},[ANZAHL]={">=1"},[BAUP_DATUM_GUELTIG_BIS]={">$(=Timestamp(Now(2)))"}>} [KUNDE_BPR_ID])

Regards, Moe.

[#2 · Accepted solution]

Oh, it was my fault. Syntax worked with only Now().