Hi guys,
This is the background of my project:
I am currently working on a Purchase Order project and some PO might contain a large amount of goods and will have to split into two delivery date hence, i come up with a delivery report whereby it will prompt user to enter the delivery date. Besides that, I have also used the DateAdd function in my delivery textbox control source =DateAdd('d',-7,[PromisedDate]). With this function, the date on the report will display 7 days in advance.
Issue:
My issue is that this function can only prompt user to key in one delivery date instead of two. I tried =DateAdd('d',-7,[1stPromisedDate] OR [2ndPromisedDate]) it did prompt user to key in two delivery date however result result returned me 22DEC1899. I want the report to prompt user to enter the delivery date twice and result will return two different delivery date that show 7 days in advance.
I do not have any idea where i goes wrong hence, I would like to seek help from expert here! I greatly appreciate any help that offer! Thank you very much!
Have a good day everyone!