ProgramRasta
Member
- Local time
- Today, 11:56
- Joined
- Feb 27, 2020
- Messages
- 98
Hello All,
I am hoping for some assistance.
I am attempting to manipulate some dates with little success!
I have a query where I concatenate two dates, however, where there is an impossible date such as 31/11/2021 the query is falling over.
I would like for the query to do the following if possible:
Cat
I am hoping for some assistance.
I am attempting to manipulate some dates with little success!
I have a query where I concatenate two dates, however, where there is an impossible date such as 31/11/2021 the query is falling over.
I would like for the query to do the following if possible:
- If the date is impossible go the next date - for example 31/11/2021 changes to 01/12/2021
- if the date is a non-weekday, make the date the next weekday
Cat