1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
| Select datepart('w',{COMMANDE.COMMANDE_START_DATE}},crmonday)
Case 1 :
Dateserial(year({COMMANDE.COMMANDE_START_DATE}),Month({COMMANDE.COMMANDE_START_DATE}),Day({COMMANDE.COMMANDE_START_DATE})-6)
Case 2 :
Dateserial(year({COMMANDE.COMMANDE_START_DATE}),Month({COMMANDE.COMMANDE_START_DATE}),Day({COMMANDE.COMMANDE_START_DATE}))
Case 3 :
Dateserial(year({COMMANDE.COMMANDE_START_DATE}),Month({COMMANDE.COMMANDE_START_DATE},Day({Commandes.Date de commande})-1)
Case 4 :
Dateserial(year({COMMANDE.COMMANDE_START_DATE}),Month({COMMANDE.COMMANDE_START_DATE}),Day({COMMANDE.COMMANDE_START_DATE})-2)
Case 5 :
Dateserial(year({COMMANDE.COMMANDE_START_DATE}),Month({COMMANDE.COMMANDE_START_DATE}),Day({COMMANDE.COMMANDE_START_DATE})-3)
Case 6 :
Dateserial(year({COMMANDE.COMMANDE_START_DATE}),Month({COMMANDE.COMMANDE_START_DATE}),Day({COMMANDE.COMMANDE_START_DATE})-4)
Case 7 :
Dateserial(year({COMMANDE.COMMANDE_START_DATE}),Month({COMMANDE.COMMANDE_START_DATE}),Day({COMMANDE.COMMANDE_START_DATE})-5) |
Partager