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.
Hi Robert,
If Export_Zeitstempel is Date Field
in script
Date(Export_Zeitstempel,'DD MM YYYY') as Export_Zeitstempel_Anzeige_Tag
Yestarday
Date(Max(Export_Zeitstempel_Anzeige_Tag) -1)
Regards,
Antonio
Hi Robert,
If Export_Zeitstempel is Date Field
in script
Date(Export_Zeitstempel,'DD MM YYYY') as Export_Zeitstempel_Anzeige_Tag
Yestarday
Date(Max(Export_Zeitstempel_Anzeige_Tag) -1)
Regards,
Antonio
Hi may be this
Today:-
DATE(max(Export_Zeitstempel_Anzeige_Tag)) as Today
Yesterday
DATE(max(Export_Zeitstempel_Anzeige_Tag)-1) as Yesterday
Regards,
Mahesh
for today:
=MaxString(Export_Zeitstempel_Anzeige_Tag)
for yesterday:
=Date((MaxString(Export_Zeitstempel_Anzeige_Tag))-1)
Thank you, but it doesn't work.
THX!
It is working fot today;
but not for yesterday.
Can You share any values of Export_Zeitstempel in Your Data ?
Hi,
Try like this
=Date(Date(MaxString(Export_Zeitstempel_Anzeige_Tag))-1)
Regards,
jagan.
sorry, doesn't work.
may be this will work
DATE(max(Export_Zeitstempel_Anzeige_Tag)-1) as Yesterday