Date Function In Tableau with Example

 Here is an explanation of various date functions in Tableau with examples:

1.TODAY():   Description: Returns the current date.

                            Example: TODAY()

2.NOW(): Description: Returns the current date and time.

                    Example: NOW()

3.DATE(): Description: Extracts the date portion from a datetime field.

                    Example: DATE([Order Date])

4.DATETIME(): Description: Combines separate date and time fields into a single                             datetime field.

                            Example: DATETIME([Date Field], [Time Field])

5.DATEADD(): Description: Adds a specified number of units (days, weeks,                                         months, etc.) to a date or datetime field.

                                Example: DATEADD('month', 3, [Start Date])

6.DATEDIFF(): Description: Calculates the difference between two dates or                                        datetimes in terms of a specified unit (days, weeks, months, etc.).

                                Example: DATEDIFF('day', [Start Date], [End Date])

7.DATEPART(): Description: Extracts a specific component (year, quarter, month,                                 day, etc.) from a date or datetime field.

                                    Example: DATEPART('year', [Date Field])

8.DATEPARSE(): Description: Converts a string into a date or datetime field using                                 a specified format.

                                      Example: DATEPARSE('dd-mm-yyyy', '20-09-2022')

9.MAKEDATE(): Description: Creates a date field using specified year, month, and                                 day values.

                                    Example: MAKEDATE(2022, 9, 20)

10.MAKEDATETIME(): Description: Creates a datetime field using specified year,                                             month, day, hour, minute, and second values.

                                                    Example: MAKEDATETIME(2022, 9, 20, 10, 30, 0)

11.MAKEINTERVAL(): Description: Creates a duration or interval field using                                                   specified values for hours, minutes, seconds, etc.

                                                    Example: MAKEINTERVAL(0, 2, 30, 0)

12.TIME(): Description: Extracts the time portion from a datetime field.

                            Example: TIME([Timestamp])

13.TIMEDIFF(): Description: Calculates the difference between two times in terms                                 of a specified unit (hours, minutes, seconds, etc.).

                                    Example: TIMEDIFF('minute', [Start Time], [End Time])

14.TIMEPARSE(): Description: Converts a string into a time field using a specified                                     format.

                                    Example: TIMEPARSE('%H:%M:%S', '12:30:45')

15.TIMEVALUE(): Description: Converts a datetime field to a time field.

                                        Example: TIMEVALUE([Datetime Field])

16.YEAR(): Description: Extracts the year from a date or datetime field.

                            Example: YEAR([Order Date])

17.MONTH(): Description: Extracts the month from a date or datetime field.

                        Example: MONTH([Order Date])

18.DAY(): Description: Extracts the day from a date or datetime field.

                        Example: DAY([Order Date])

19.WEEKDAY(): Description: Returns the weekday (as a number, where Sunday is                                     1) from a date or datetime field.

                                    Example: WEEKDAY([Order Date])

These are just a few examples of date functions available in Tableau. Each function serves a specific purpose and can be used to manipulate, analyze, or format date and time values in your data. The choice of function depends on the specific date-related calculations or transformations you need to perform.