Schedule Date for Sales Order
Posted: Wed Mar 01, 2006 3:44 am
Hi All,
I have to find out the day of the week for a particular schedule date. Now the problem is, the OCONV(Date(),'DW') function works fine when system date is given as an input because the Date() function returns an internal number. But i am having the schedule date comming from a source file.
I have to read date from the source file, add 30 days to it and, check the day of the week for it. if day of the week falls on weekend then postpone delivery date to next monday.
Now i'd implemented this logic with system date successfully, but the OCONV() function is not working for direct date supplied from a source file.
Can someone help me for it
I have to find out the day of the week for a particular schedule date. Now the problem is, the OCONV(Date(),'DW') function works fine when system date is given as an input because the Date() function returns an internal number. But i am having the schedule date comming from a source file.
I have to read date from the source file, add 30 days to it and, check the day of the week for it. if day of the week falls on weekend then postpone delivery date to next monday.
Now i'd implemented this logic with system date successfully, but the OCONV() function is not working for direct date supplied from a source file.
Can someone help me for it