25 Replies Latest reply: Sep 28, 2016 5:56 AM by Anil Babu RSS

    How to switch between today and yesterday

    Robert Ebner

      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.