Good day,please I need to add hint on my query parameter e.g format of d date to b entered.
B brodaman Registered User. Local time Today, 15:54 Joined Nov 23, 2015 Messages 25 Dec 22, 2015 #1 Good day,please I need to add hint on my query parameter e.g format of d date to b entered.
arnelgp ..forever waiting... waiting for jellybean! Local time Today, 21:54 Joined May 7, 2009 Messages 19,246 Dec 22, 2015 #2 just make a parameter [Enter Date (dd/mm/yyyy):]
B brodaman Registered User. Local time Today, 15:54 Joined Nov 23, 2015 Messages 25 Dec 22, 2015 #3 it has worked for [Enter Date] did not work for [start Date] and [End Date] with format.
arnelgp ..forever waiting... waiting for jellybean! Local time Today, 21:54 Joined May 7, 2009 Messages 19,246 Dec 22, 2015 #4 on your query you should use Format() in your Expression: Start Date: Format([Start Date], "mm/dd/yyyy") End Date: Format([End Date], "mm/dd/yyyy")
on your query you should use Format() in your Expression: Start Date: Format([Start Date], "mm/dd/yyyy") End Date: Format([End Date], "mm/dd/yyyy")
B brodaman Registered User. Local time Today, 15:54 Joined Nov 23, 2015 Messages 25 Dec 22, 2015 #5 How do I include hint on d start and end parameter please.