Forum Discussion

Boycie92's avatar
Boycie92
Icon for Resolver I rankResolver I
9 years ago
Solved

First and Last Date a product was bought

Hi,   I am hoping someone could help.   I have a table that contains product ID (numerous different products) and Transaction Date   I want to be able to identify the First Date a product was...
Need Help
Show and Tell
vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
9 years ago

Boycie92 

 

this might work?

 

datetype=
IF (
transactiondate = FIRSTDATE ( transactiondate ),
"first date",
IF ( transactiondate = LASTDATE ( transactiondate ), "last date", "n/a" )
)

 

 

Boycie92's avatar
Boycie92
Icon for Resolver I rankResolver I
9 years ago

Hi,

 

vanessafvg

 

Thanks for the reply. I have tried it and for some reason all I am getting is "first date" for every row/product?

 

Any ideas why?

 

Thanks,

 

Boycie92