7 Replies Latest reply on Dec 22, 2016 5:10 AM by Tom W

# Convert Solar Calendar to Lunar Calendar

Hi everybody,

I come from in VIetNam. In my country, the most of people use Lunar calendar to evaluate business activities.

In Tableau, How I can to change Solar Calendar to Lunar Calendar?

• ###### 1. Re: Convert Solar Calendar to Lunar Calendar

Hi Tran,

It would be helpful if you could provide an example of the calendar you're trying to implement or a link to a description.

• ###### 2. Re: Convert Solar Calendar to Lunar Calendar

Ex: Today is 21/12/2016, it's solar calendar . It's equal 23/11/2016 lunar calendar.

You can see Chinese Calendar: Lunar Calendar Converter, Auspicious Days, Holidays, Zodiac Years  other date.

I have algorithms to calculated it, but not in Tableau Thuật toán tính âm lịch

• ###### 3. Re: Convert Solar Calendar to Lunar Calendar

There's not inbuilt support in Tableau as far as I'm aware. I think your best bet would be to create a 'Calendar' table or source you join to in order to fetch these details.

 Gregorian Date LunarPeriod LunarYear LunarDay 1/1/2016 11 2015 22 1/2/2016 11 2015 23 1/3/2016 11 2015 24 1/4/2016 11 2015 25 1/5/2016 11 2015 26 1/6/2016 11 2015 27 1/7/2016 11 2015 28 1/8/2016 11 2015 29 1/9/2016 11 2015 30 1/10/2016 12 2015 1

You could join to this table using the western date and use the supporting details from this table.

1 of 1 people found this helpful
• ###### 4. Re: Convert Solar Calendar to Lunar Calendar

Hi Tran

Interesting Challenge.

Let me try, but do you have long term cross reference table between Gregorian and Lunar Calendar?

If you have, please provide me with the table thru text or excel, whatever.

That helps me to verify the simplified logic.

Thanks,

Shin

• ###### 5. Re: Convert Solar Calendar to Lunar Calendar

But it is not correct in this case. Lunar calendar is not same Solar calender, The first day new year is can change after about 4 year.

You don't change Solar calender to lunar calender by Hand.

Shin. You can read the logic this case in

• ###### 6. Re: Convert Solar Calendar to Lunar Calendar

Tran,

Are you able to attach simple conversion table for let's say 50 years or so?

2000~2050.

Thanks,

Shin

• ###### 7. Re: Convert Solar Calendar to Lunar Calendar

The specs to convert this are extremely lengthy. Unless someone has already done this before, I think you're asking a lot for someone to implement this for you in Tableau.

Given that you've done this yourself before, perhaps you should parse the date / make the conversion outside of Tableau first, then bring your converted data in and visualize that.

Good luck!