Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good morning all,
i have the following problem:
I have data with a calender-dates.
day(Export_Zeitstempel)&' '&month(Export_Zeitstempel)&' '&Year(Export_Zeitstempel) as Export_Zeitstempel_Anzeige_Tag, |
My calender is called: Export_Zeitstempel_Anzeige_Tag
Now, I would like to visualise two text-bosxes which switch between today and yesterday.
My solution was:
for today:
=MaxString(Export_Zeitstempel_Anzeige_Tag)
for yesterday:
=(MaxString(Export_Zeitstempel_Anzeige_Tag))-1
Both doesn't really work.
Any ideas? Thank you for helping.
"23 Sep 2016"
I think this is not the input for a textbox, isn't it?
Why these all not working, because we don't know what you have done over there. Would you provide few more input's like Date field and then expect out which you need. So that, it could be better approach
It's possible, Minstring and Maxstring should work on textbox?
in script
Date(Date#(Export_Zeitstempel,'DD MMM YYYY'),'DD MM YYYY') as Export_Zeitstempel_Anzeige_Tag
Yestarday
Date(Max(Export_Zeitstempel_Anzeige_Tag) -1)
I am tryiing to:
This is how i generate my field in the script:
day(Export_Zeitstempel)&' '&month(Export_Zeitstempel)&' '&Year(Export_Zeitstempel) as Export_Zeitstempel_Anzeige_Tag
This is the result in the table:
"23 Sep 2016"
I have two textboxes in my visualation:
Today:
=MaxString(Export_Zeitstempel_Anzeige_Tag)
Yesterday
is not working ...
Hope I could explain it better, so that you can help me.
Thank you very much
Robert, Try to provide inputs from that field
=MaxString(Text(Export_Zeitstempel_Anzeige_Tag) - 1)
if I put it as text in a textbox:
the result is "-"
No more ideas?
Final Luck from my end, What is your intention to show using that expression?