Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problema con campo calculado today()

Good day,

I have a problem with the current date, and need to make a daily count of the previous to the current date manualmete this without editing the current date , then in this case I works like this:

= Count ( { < [ Effective Date Quote ] = {' > = 03.20.2015 ' } >} Sales )

but I need evaluate the Today () within the función.en instead of : ' > = 20.03.2015 '

Thank you very much for your attention stay tuned ...

1 Solution

Accepted Solutions
jaimeaguilar
Partner - Specialist II
Partner - Specialist II

Hi,

you can do something like this:

= Count ( { < [ Effective Date Quote ] = {"$(=date(today(), 'DD.MM.YYYY')) " } >} Sales)



just for you to notice, if your default date format is set to 'DD.MM.YYYY', then you don't need to specify the format within set analysis, this is just in case (the default date/time format can be set in the first script tabs where all the environment variables are declared).

Also take care of the use of single and double quotes. In this example i'm using double quotes for enclosing the expression and single quotes for setting the date format in case you need to set it.


regards

View solution in original post

2 Replies
jaimeaguilar
Partner - Specialist II
Partner - Specialist II

Hi,

you can do something like this:

= Count ( { < [ Effective Date Quote ] = {"$(=date(today(), 'DD.MM.YYYY')) " } >} Sales)



just for you to notice, if your default date format is set to 'DD.MM.YYYY', then you don't need to specify the format within set analysis, this is just in case (the default date/time format can be set in the first script tabs where all the environment variables are declared).

Also take care of the use of single and double quotes. In this example i'm using double quotes for enclosing the expression and single quotes for setting the date format in case you need to set it.


regards

Not applicable
Author

Yeah thks for your time!!!!!!