DSXchange

Hi,

We are trying to use Column generator stage to generate two dates in a column as following

Column1
________
2009-08-04
2009-08-05
2009-08-04
2009-08-05
2009-08-04
2009-08-05
2009-08-04
2009-08-05


I have used the following setting in teh Edit row option
Type: Cycle
Inital Value: 2009-08-04
Limit: 2009-08-05

But the output gives some default dates like
1960-02-03
1960-02-04
1960-02-06
1960-02-05
1960-02-09
1960-02-01
1960-02-08
1960-02-07

Thank you.
WFIS

The Epoch property sets the earliest date to be used.

It defaults to 1960-01-01.

I set the Epoch value to 2000-01-01 with Initial Value: 2009-08-04 and Limit: 2009-08-05.


This i receive the following dates
2005-07-02
2005-07-02
2005-07-02
2005-07-02
2005-07-02
2005-07-02
2005-07-02

Any other option missing?

I even tried giving Epoch to 2009-08-04 it does not work.

Thank you
WFIS

Have you left increment at 0 ?

Can you generate random dates in your epoch?

Also try not having an initial value - after all, the Epoch property does that.

You can try with the following options:

Epoch: 2009-08-04
Type: Cycle
Increment: 1
Limit: 1