1 of 1 people found this helpful
Tableau doesn't have time only (duration) fields as a separate type. You can either represent them as numeric fields (ideally with 1 day = 1), or as date time fields all on a particular day.
You can just change the data type on all your start and end fields to Date Time and they will work fine. There's no need to use DATEPARSE at all.
If you do want to use DATEPARSE, you aren't using it correctly. The first parameter is supposed to the date format and the second parameter is the field you are trying to parse.
If you want to make date time fields that all exist in a particular day, you can do something like:
That will map [Start] to the corresponding time in #1/1/2001#.
If you want to represent them as numeric fields, you can do:
I think it is easier to make Gantt charts with date time fields.