Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
qvraj123
Contributor II

inmonth([Complete Date],[Start Date],0) - to use this - do we need to have timestamp

Hi All,

Thanks for your time - this might be answered but when I use this in WHERE clause I do not get the data (I expect some data) - so want to confirm if the first date field argument has to be timestamp only or it is ok if the first date field has MM/DD/YYYY

 

 inmonth([Complete Date],[Start Date],0) - This failed in my where clause ; before where clause we have used

DATE(FLOOR(Complete Date),'MM/DD/YYYY') AS Complete Date - Is this causing the fail? or I should be fine -

I am looking to see if the condition is true

agains thanks a lot

 

 

2 Replies

Re: inmonth([Complete Date],[Start Date],0) - to use this - do we need to have timestamp

Hi,

Can you share the script which you are using?

 

Regards,

Kaushik Solanki

Vegar
Honored Contributor

Re: inmonth([Complete Date],[Start Date],0) - to use this - do we need to have timestamp

I notice you are not wrapping your field name with "" or [] .
DATE(FLOOR(Complete Date),'MM/DD/YYYY') AS Complete Date

Try changing it to
DATE(FLOOR([Complete Date]),'MM/DD/YYYY') AS [Complete Date]
Please ekskuse my Norglish and Swenglish typos.