i have been trying find way create custom time range need report.
i have column datetime got weekday.
i want create daypart datetime meet following criteria:
- if day between monday , friday, , time between 10:00 3:00 pm return mf10a-3p, , if between 6:00 pm 10:00 pm, return
mf6p-10p, etc. - for weekends, want same time range
sa,susaturday , sunday respectively.
datetime in format given below, , weekday monday. want write daypart on csv:
12/5/2016 3:02
Comments
Post a Comment