Forum Discussion
Date Separation - separating dates from timestamps
I am accessing Redshift data via direct query (not loading the data as the update cycles are hourly). The date is in a timestamp format in the originating table. How can I separate the date from th...
The second formula was cut off:
Last 7 Days = VAR Last_Date =lastdate(daily_stats[date]) return CALCULATE(devices_captured[Segment_Count], FILTER(ALL(daily_stats[date]),daily_stats[date]>Last_Date -7 && daily_stats[date]<= Last_Date))