Date in Label Nprinting

[Anonymous]

hi,

i want to insert a function:

date( today()-2 , 'dd MMMM yyyy' )

in  PixelPerfect label. It's possibile?

i've .qvw source also and i just create same expression as variable vToday.

How can i use it in a Label ?

Thank you

[Ruggero_Piccoli]

Add it into the Variables node, then drag and drop into the template.

Best Regards,

Ruggero

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

[Anonymous]

It dosen't works 'cause it display only a formula (expression)

[Stephen_Jasionowski]

Did you bind the formula/variable to the label object?

[Lech_Miszkiewicz]

it is because you want your date to evaluate before beeing pass to template

If it is in variable - put  "=" sign before your expression, or use the same on template level and create NPrinting formula instead.

cheers

Lech

[Ruggero_Piccoli · Accepted solution]

Hi,

Use this formula instead:

=text(date( today()-2 , 'dd MMMM yyyy' ))

text() will force the output to be a string so PixelPerfect will interpret it correctly.

Best Regards,

Ruggero

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

[Anonymous]

Grazie Ruggero

It works!