Dates in Variables but Formatting Issue In Textbox

[Peter_Brunner]

Hi All,

I have been trying several different ways to Display a Date which actually is in correct Format in a Variable

but when I try to display this in a text box I can not get it to format correctly?

see attachment

any Help appreciated and is there any quick reference sheet with formatting dates in script expressions, text boxes etc.;?

thanks Peter

[swuehl]

Peter, not sure what the issue is, I've created a text box and used

=vDateFromDisplay

and got back

13/06/16

[sunny_talwar]

Try this:

='From Date'&'  ' &vDateFromDisplay&' '&'To Date ' &$(vDatesTo)&'   '&'........I need this to show 13/06/16'

[swuehl]

The complete expression with from and to date then looks like

='From Date'&'  ' & vDateFromDisplay &' '&'To Date ' & vDatetoDisplay

Reason why your version did not work:

After the dollar sign expansion the expression looks like

='From Date'&'  ' & 13/06/16  &' '&'To Date ' & vDatetoDisplay

and 13 divided by 6 divided by 16 equals to 0,13541666666666666666666666666667

[Peter_Brunner]

Hi Stefan,

thanks for this

I was trying to using these formats

$(vDateFromDisplay)  or   ' $(vDateFromDisplay) '  but did not use vDateFromDisplay

also your explanation makes sense now why I was getting decimal value

It would be good to get these rules straight where to use what format e.g.:  Script , Expression Textbox for variables

Thanks again

regards Peter

[Peter_Brunner]

Stefan,

I wish to mark your answer correct ...I always have trouble seeing this Correct answer button , all I see is the actions drop down and mark a Helpful !!

How do I navigate to this button correctly ?...currently my discussion is waiting for Moderation to accept my reply

does this have an effect on this button ...tried 2 browsers but I can not see it in either

I think a lot of other users have this very same issue!

thanks Peter

[swuehl]

You should be able to see the button when opening the full thread in the browers (not viewing from within the inbox)

Qlik Community Tip: Marking Replies as Correct or Helpful

[Peter_Brunner]

Hi Stefan,

I have read your link but  No Go, I can not see button ..see below what i see this page has white back ground and I clicked by hit heading

Stefan please explain step by step how I get to this button ?

see below this is what I see this page has white back ground and I clicked by hit heading

this page I am looking at .....the address =.Dates in Variables but Formatting Issue In Textbox

Peter

[swuehl]

It seems like you haven't marked the discussion as question, so there is no option to mark it as answered

(not sure if you can set it to closed at all, is there an option at the very top, near the first post?).

If there is an option to close the thread in any way, do so. If not, don't worry.

Regards,

Stefan

[Peter_Brunner]

Hi Stefan,

I have checked but there is no way I can see to close it ...I have looked under Edit but nothing to fix this,

also I have re loaded a new discussion and I noticed that the mark for discussion box is ticked by default ??

and why would it let me mark it Helpful if it was not a question?

anyway I will double check next discussion I do , it seems very erratic very frustrating not knowing !

sorry Stefan

thanks again

regards Peter