on 08-11-2023 8:09 PM
Hello
I'd like calculate date in past by puting duration in days and result pass it to SQL Query for put in where statement as timestamp limit.
My fomula is below, unfortunetly in expression editor cliking evaulation no return value and terefore no SQL Query result
dateformat(dateadddays(datenow, -Transaction.duration), "yyyy-MM-dd'T'hh:mm:ss" , "dd/MM/yy" )
However part of above code:
dateadddays(datenow, -Transaction.duration)
return to me below date after click evaluate in expression editor:
2023-08-10T20:52:27
so date format is
yyyy-MM-dd'T'hh:mm:ss
but function dateformat cannot convert to my format "dd/MM/yy"
When I puting date string in expression editor instead 1st expression like "08/11/23" all is working fine. Where I made mistake?
Reference link
Hi Steve.
Thank you for answer, unfortunely not help but after read again documantation found issue:
h Hour in AM or PM (1-12) Number 12
H Hour in the day (0-23) Number 21
After change from lower case to upper case "H" start working
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
After many hours found that trx attribut LegacyProcessingMode = true resolve my problem however how to fix without this mode?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
4 | |
3 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.