if you want the date in Hijri format you will have to update.
- Log in to post comments
if you want the date in Hijri format you will have to update.
Hi Omar,
Here you have the values
w $ZDT($H,18)
14 Muharram 1442 12:22:31
w $ZDT($H,19)
14 1 1442 12:22:37
w $ZDT($H,20)
14 Muharram 1442 12:22:40
w $ZDT($H,21)
14 1 1442 12:22:44
Hi Birun,
Try this
w $ZD($H,12)
Tuesday
Regards.
Hi Javier,
After execute both methods try this if the rowcount bigger than 0
d QueryResultSet.Rewind()
d QueryResultSet.Next()
Also you can try to delete the single quote when you put the parameter
MyParam >= '?' --> MyParam >= ?
When you use the ExecuteQuery , you can directly send the stringlike this
Set par = "20160630"
Set sql = "SELECT Cod, Ing, score FROM [bbdd].[dbo].[vw_Test] WHERE MyParam >= ?"
Set tSC = ..Adapter.ExecuteQuery(.QueryResultSet,sql,par)
It's not necessary the array.