All these time stamps are local time zone timestamps.
What I need to create in a report is show Number of loads today
In this case it should be 1 load for each region for 09/17/2009
How do I adjust my expression for showing this as loaded for 24 hrs period (per region)
Can I use daynumberofyear(converttolocaltime(Today()) ) = daynumberofyear(loaded_dt)
and it will automatically adjust to 24 hour period match for that particular region where the report is opened?
i.e if i open the report in dubai does converttolocaltime() mean 24 hours for that particular region - does the report adjust this expression based on where it is opened?