Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need to create a Last Year table and that's what I do:
original table:
Timestamp,
addyears (Timestamp,-1) as Timpestamp_ly,
net_price,
status;
LY_table:
Timestamp as Timpestamp_ly,
net_price as net_price_ly,
status;
The problem of this structure is that LY_table uses the status field of the current timestamp, I mean that if the status of the actual timestamp doesn'tmatch with the status of the last year timestamp the LY_table doesn't work.
The only way it works is if I name the status field as status_ly in the LY_table but I need to keep the old name to compare both net_prices in a graph
I don't know if it's clear...
Any Idea??
Regards, David
I would use a date function while look to use Year from Timestamp
like Time stamp gives u complete date and time for particular field
Date(Timestamp, 'MM/DD/YY') gives you just date from same time stamp
Sorry, I don't understand...
First of all r u talking abt tables in QV or on DB side?
QV tables,
Do you mean trunking by day to get more range of Status?
Thanks,
David