Hello,
Using Windev 22, HFSQL 22
When I try to run the below query in WDSQL ( against HFSQL Classic files)
SELECT a.accountnamefk, a.voucherdate, DateToString(a.voucherdate, 'DD/MM/YYYY')
FROM gl_transaction_detail a
I get the following error:
In this version, the stored procedures are not supported in HFSQL Classic or HFSQL Mobile.
Error detected:
a.accountnamefk, a.voucherdate, >>>>DateToString(a.voucherdate, 'DD/MM/YYYY')<<<<<
How to split a date value stored in a file into day, month, year in HFSQL query ?
Happiness Always
BKR Sivaprakash