Currently using YYYY-MM-DD string for date format, but the strftime function when using a modifier isn't returning a value.
"SELECT strftime('%W', 'Week'), Week, Sum(CRED) FROM Temp_Table GROUP BY Week;"
Put revDataFromQuery(tab, return, gDatabaseID, tSQL) into field
I've not been able to figure out what's up.
Strftime() Function
Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller
Re: Strftime() Function
Hi,
"SELECT strftime('%W', Week) ..." or
"SELECT strftime('%W', Temp_Table.Week) ..."?
The second notation is what I use - "SELECT strftime('%Y,%m,%d,%H,%M,%S,%w', MyTable.MyField) ..." to get the dateItems.
Have fun!
Have you tried already:Not a lot of thought wrote:"SELECT strftime('%W', 'Week'), Week, Sum(CRED) FROM Temp_Table GROUP BY Week;"
"SELECT strftime('%W', Week) ..." or
"SELECT strftime('%W', Temp_Table.Week) ..."?
The second notation is what I use - "SELECT strftime('%Y,%m,%d,%H,%M,%S,%w', MyTable.MyField) ..." to get the dateItems.
Have fun!
All code published by me here was created with Community Editions of LC (thus is GPLv3).
If you use it in closed source projects, or for the Apple AppStore, or with XCode
you'll violate some license terms - read your relevant EULAs & Licenses!
If you use it in closed source projects, or for the Apple AppStore, or with XCode
you'll violate some license terms - read your relevant EULAs & Licenses!