Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have a QV doc , which is compute the pricing list . and from time to time the raw data list price will be updated. for example today 27/5/2014 have new list price need to update. and i need 27/5/2014 date to be appear in one of the column. Any idea how to do it ?
Paul
If you dont refresh daily, then add Today() in your script and use expression Max(UpdDt) to get updated date
HAKKO:
LOAD
left(FileBaseName(), 4) AS V6,
// Model,
Model as PART_NO_,
// Model as Product,
Description,
'HAKKO' AS BRAND_P,
'Fuji' as [Supplier],
'V6 & S8' as [Product Group],
S_Price as LIST_PRICE_,
S_Price as LIST_PRICE,
[Category 1],
[Category 2],
'1' as [HQuantity],
Today() As UpdDt
//FROM FCS SG TDS price list.xls (biff, header is 5 lines, embedded labels, table is [TDS$]);
//FROM V8 Price List_.xls (biff, embedded labels, table is [Ecomony Model$]);
FROM $(vRAWPath)V8 Price List_.xls (biff, embedded labels, table is [Ecomony Model$]);
Hi All
Enclosed my QV doc sample.
Paul
Do you want to display current date in all the rows? Then use Today()
Hi Paul,
If you want to display Todays date in all the rows then simply use
=Today() as expression.
Hope this helps you.
Regards,
Jagan.
Hi Sir
I want to use the date I update. It is today . But after update in case tomorrow i reload again . Can the date don't change to tomorrow date ?
Paul
Sent from Samsung Mobile
Hi,
may be like this.
Regards
ASHFAQ
Yes. Today() will give you current date.
If you dont refresh daily, then add Today() in your script and use expression Max(UpdDt) to get updated date
HAKKO:
LOAD
left(FileBaseName(), 4) AS V6,
// Model,
Model as PART_NO_,
// Model as Product,
Description,
'HAKKO' AS BRAND_P,
'Fuji' as [Supplier],
'V6 & S8' as [Product Group],
S_Price as LIST_PRICE_,
S_Price as LIST_PRICE,
[Category 1],
[Category 2],
'1' as [HQuantity],
Today() As UpdDt
//FROM FCS SG TDS price list.xls (biff, header is 5 lines, embedded labels, table is [TDS$]);
//FROM V8 Price List_.xls (biff, embedded labels, table is [Ecomony Model$]);
FROM $(vRAWPath)V8 Price List_.xls (biff, embedded labels, table is [Ecomony Model$]);
Hi Sir
I have try your approach , it work fine,Totally i have total 9 diff QV price doc all work fine , when i combine all 9 QV doc , and i use max(updDt) it display the final QV doc as number instead of date , why ? where i go wrong ?
Hi Paul,
go to chart properties -->number tab-->Select update-->and select date as format.
Regards
ASHFAQ