I am creating custom date but i am getting some issue
+ "/" + STR(DATEPART('day', [date_of_loss]))
+ "/" + STR(DATEPART('year', [date_of_loss]))
+ STR(17)+ " :"
+ STR(0)+ " :"
this give result 11/01/2013 12:00:17 AM
I need this result 11/01/2013 05:00 PM
can you please guide me ??
Tracy Rodgers Alex Kerin Kelly Osterhout Gourav Kumar
I wouldn't convert the dates into strings and back again - [date of loss]+(17/24) should give you 5pm, then format the resulting datetime however you would like.
Times are represented by fractions of a day.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...