Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Update date and skip sunday
Message
From
07/05/2022 08:37:20
 
 
To
05/05/2022 15:01:10
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01684337
Message ID:
01684346
Views:
38
>search help for dow()
>
>HTH
>thomas
>
>>
>>CREATE table date_step (sno n(6),datex date, subject C(20))
>>SET DATE TO DMY
>>
>>INSERT into date_step(sno,datex,subject) VALUES (1,{^2022-05-02},'science')
>>INSERT into date_step(sno,datex,subject) VALUES (2,{^2022-05-03},'science')
>>INSERT into date_step(sno,datex,subject) VALUES (3,{^2022-05-04},'science')
>>INSERT into date_step(sno,datex,subject) VALUES (4,{^2022-05-05},'science')
>>INSERT into date_step(sno,datex,subject) VALUES (5,{^2022-05-06},'science')
>>INSERT into date_step(sno,datex,subject) VALUES (6,{^2022-05-07},'science')
>>INSERT into date_step(sno,datex,subject) VALUES (7,{^2022-05-09},'science')
>>INSERT into date_step(sno,datex,subject) VALUES (8,{^2022-05-10},'science')
>>INSERT into date_step(sno,datex,subject) VALUES (9,{^2022-05-11},'science')
>>INSERT into date_step(sno,datex,subject) VALUES (10,{^2022-05-11},'science')
>>
>>Now I want to update record like this. 
>>start from new date and skip Sunday
>>
>>
>>INSERT into date_step(sno,datex,subject) VALUES (5,{^2022-05-02},'science')&& start from 5
>>INSERT into date_step(sno,datex,subject) VALUES (6,{^2022-05-03},'science')
>>INSERT into date_step(sno,datex,subject) VALUES (7,{^2022-05-04},'science')
>>INSERT into date_step(sno,datex,subject) VALUES (9,{^2022-05-05},'science')&& skip sunday
>>INSERT into date_step(sno,datex,subject) VALUES (10,{^2022-05-06},'science')
>>INSERT into date_step(sno,datex,subject) VALUES (11,{^2022-05-07},'science')
>>INSERT into date_step(sno,datex,subject) VALUES (12,{^2022-05-09},'science')
>>INSERT into date_step(sno,datex,subject) VALUES (13,{^2022-05-10},'science')
>>INSERT into date_step(sno,datex,subject) VALUES (14,{^2022-05-11},'science')
>>INSERT into date_step(sno,datex,subject) VALUES (16,{^2022-05-11},'science')&& skip sunday always skip sunday
>>...................................................
>>
>>
yes but how to skip date
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform