Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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
Valued Contributor II

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.