Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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.

samvile18
Contributor II

Script help required please

Morning all,

I have a date field named CRDATE, I need to write some script to tell me the number of working days between CRDATE and Today()...I'm struggling with the syntax, can anyone out there help me please?

Any help is greatly appreciated.

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Script help required please

This should work as long as CRDATE is a date field and not a string: networkdays(CRDATE, today() ). If CRDATE is a string you first have to use the date# function to create a date from it.


talk is cheap, supply exceeds demand
2 Replies
MVP & Luminary
MVP & Luminary

Re: Script help required please

This should work as long as CRDATE is a date field and not a string: networkdays(CRDATE, today() ). If CRDATE is a string you first have to use the date# function to create a date from it.


talk is cheap, supply exceeds demand
samvile18
Contributor II

Re: Script help required please

Excellent, thanks for the help.

Community Browser