Datetimetrim alternative for tableau calculation

[Jarviz]

Hi community,

i am trying to convert the below expression to tableau calculation. Could you please help?

datetimetrim([date],’day’)

[Deano478]

Hey @Jarviz i'm not very familiar with Tableau but you can try this?

DATEPART('day', [date])

[caltang]

Are you trying to get the day of the date? If yes, you could try:

DateTimeFormat([date],"%A")

[Samantha_Jayne]

All the date time functions can be found here:

https://help.alteryx.com/20231/designer/datetime-functions 

[Jarviz · Accepted solution]

never mind i got it. It was just trimming the time format and retaining the date. Thanks all for your valuable comments.