System Dates

hobanwashburne — Tue, 23 Jul 2013 18:54:21 GMT

I’ve looked at a couple examples, but I’m not getting the results that I expected.

Could someone please enter the correct code for thefollowing variables?

Let vDate01 = Today’s Date in YYYYMMDD format

Let vDate02 = Today’s Date in MM/DD/YYYY format

Let vDate03 = Yesterday in YYYYMMDD format

Let vDate04 = 10 Days ago in YYYYMMDD format

Let vDate05 = Current month, in YYYYMM format

Let vDate06 = Three months ago, in YYYYMM format

Re: System Dates

jerem1234 — Tue, 23 Jul 2013 19:05:42 GMT

Try these formulas:

1. =Date(today(), 'YYYYMMDD')

2. =Date(today(), 'MM/DD/YYYY')

3. =Date(today() -1, 'YYYYMMDD')

4. =Date(today() -10, 'YYYYMMDD')

5. =Date(today(), 'YYYYMM')

6. =Date(addmonths(today(),-3), 'YYYYMM')