Date Table with Year, Qtr, Month, Week, Day, Date

Z

Ziggy

Active Member

Joined

Feb 15, 2002

Messages

346

• Jul 23, 2003

• #2

Explain what you are trying to accomplish, perhaps your answer may be in an "Expression".

ziggy

 

Upvote 0

P

PaddyD

MrExcel MVP

Joined

May 1, 2002

Messages

14,234

• Jul 24, 2003

• #3

i've heard of cross posting, but not noticed someone doing it on the same board before!

http://www.mrexcel.com/board2/viewtopic.php?p=264714&highlight=#264714

...clearly, i have no idea if that's what the op meant.

 

Upvote 0

Z

Ziggy

Active Member

Joined

Feb 15, 2002

Messages

346

• Jul 24, 2003

• #4

No kidding! I hate when people don't respond to their posts

 

Upvote 0

V

Venkatraman

New Member

Joined

Dec 11, 2002

Messages

7

• Jul 24, 2003

• #5

I have to store Year, Qtr, Month, Week, Day, Date in a table, the Primary Key is Date - this table will be the main source of reference for all orders coming in.

 

Upvote 0

P

PaddyD

MrExcel MVP

Joined

May 1, 2002

Messages

14,234

• Jul 24, 2003

• #6

in the linked thread, I gave you an excel procedure for this. once done, just bring the table into access...

 

Upvote 0