instead of Timestamp sql function in QV Load Script
Hello All...
i have this syntax in sql syntax :
----------------------------------------------
SQL
SELECT
Year
,Month
,GacBranchRef
,GacSecondDetailAccountRef
,GacFourthDetailAccountRef
,sum(Credit) - sum(Debit) as mandeh
, Date(Floor(Timestamp(item.VoucherDate,'DD/MM/YYYY hh:mm:ss')),'DD.MM.YYYY') as VoucherDate
FROM
----------------------------------------------
when i run that in qv script , don't identify Timestamp function (and maybe Date function) .because sql haven't Timestamp function, and maybe Date function)
