0

Find on View (Today, Last Week 5 days, Last Month, Last Six Month and Year. )

Need a script that find the info by (Today, Last Week 5 days, Last Month, Last Six Month and Year.)

Somebody helpme.

2 Antworten

null
    • Torsten_Stang.1
    • vor 11 Monaten
    • Gemeldet - anzeigen

    Did something similar last days:

    here's the code of the view:

    switch Anzeigezeitraum do
case 1:
    (select Lieferposition)[Lieferung.Datum > date(year(now()), month(now()), day(now()) - 7)]
case 2:
    (select Lieferposition)[Lieferung.Datum > date(year(now()), month(now()), day(now()) - 14)]
case 3:
    (select Lieferposition)[Lieferung.Datum > date(year(now()), month(now()) - 1, day(now()))]
case 4:
    (select Lieferposition)[Lieferung.Datum > date(year(now()), month(now()) - 3, day(now()))]
case 5:
    (select Lieferposition)[Lieferung.Datum > date(year(now()) - 1, month(now()), day(now()))]
default:
    (select Lieferposition)
end
      • Rafael_Sanchis
      • vor 11 Monaten
      • Gemeldet - anzeigen

       

      Thanks a lot Torsten appreciate your time.

Anmelden, um zu antworten

Content aside

Kategorien

Alle Themen anzeigen
  • Status Answered
  • vor 11 MonatenZuletzt aktiv
  • 2Antworten
  • 42Ansichten
  • 2 Folge bereits