Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I have Created Composite key . i am getting result in list box like .
1/1/20161/2/20161/3/2016
But I need
1/1/2016
1/2/2016
1/3/2016
is it possible.
How does you load statement look like?
Hi Sunny,
like
Date&Date1&Date2 as key
Perhaps you need to Concatenate them like:
Load Date From <>;
Concatenate
Load Date1 From <>;
Concatenate
Load Date2 From <>;
Hi tresesco,
I am getting all date field in only one table
To get all dates field into a single date field you can try the way I suggested. You can refer the same table multiple times for multiple fields, that would not be an issue. But now I suspect, that alone would not resolve your business issue. You have to re-visit your data modelling.
Perhaps the following blogs can help here: