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