3 Replies Latest reply on Aug 8, 2016 8:11 AM by Benjamin Greene

    extract day and time from datetime field(not month and year)

    Samyak Shah

      So i have this column named end time from which i want to create a field which has dd hh:mm:ss(instead of dd/mm/yyy hh:mm:ss)

      i want this because i am making a chart which has data about current month and previous month and making overlapping line charts about the 2 months data. if i choose just the day, i cannot show what time of the day the data was entered and if i put two columns day and time on x-axis it makes very huge graph whr it shows 24 hrs of each day plus  it has gaps.

      is there any function or any kind of calculation i can use?