How to get 7 days less than current date in format mm/dd/yyyy?

**kassem** · 05-22-2014, 06:22 AM

I have a textbox called text5 and i want it to be equal to a string which is in the format mm/dd/yyyy. This value must be 7 days less than the current date.

Thanks for Your Time.

**ranman256** · 05-22-2014, 06:32 AM

x = dateadd("d",-7,date())

How to get 7 days less than current date in format mm/dd/yyyy?

Thread Tools

How to get 7 days less than current date in format mm/dd/yyyy?

Similar Threads

I need to show date in format dd/mm/yyyy

Can access format a date in an odd way? DD-MMM-YYYY

UK Date Format In Linked Table ("dd/mm/yyyy")

Return Records X-amount of days to current date

Convert date mm/dd/yyyy to January 1, 2009 format

Posting Permissions