CODEWITHSUNDEEP
functiondatetableau-desktop
Venkat T
Venkat T

Reputation: 11

Date functions using tableau

I have to convert date using tableau functions "FY23Q1" to "2023-Q1"

Example DATE FY23Q1 FY23Q2 FY23Q3

To be updated as 2023-Q1 2023-Q2 2023-Q3

Upvotes: 0

Views: 44

Answers (1)

Anıl Hut
Anıl Hut

Reputation: 51

I think your date field is string type.("FY23Q1") If your dates are not less than 2000, you can create a calculation like this:

REPLACE(LEFT([YourData],4)+"-"+RIGHT([YourData],2),"FY","20")

Upvotes: 1

Related Questions