How to convert excel date (E.g. 45000) so it can be compared in make?

How To
, ,
1

Hi Team,

I am working with the List_Table_Rows Excel module. For a date column, it returns numbers like 46792 to represent 05/07/2024.

My question is how can I convert 46792 into a usable format so it can be used in Filers. (E.g. DateTime Operators Later then)

Thanks for your help!

3

In Excel, the number representing a date is the number of days since Epoch.

So to convert it to a date, you can multiply it by 86400, and then use the parseDate function.

According to the Tokens you can use to parse a date variable, you can use X.

e.g.: {{ parseDate(46792 * 86400; "X") }}

For more information, see Date Formats in the Help Center.

samliew – request private consultation

Join the Make Fans Discord server to chat with other makers!

4 Likes
4

That is excellent! Thank you

2 Likes
5

No problem, glad I could help!

1. If anyone has a new question in the future, please start a new thread. This makes it easier for others with the same problem to search for the answers to specific questions, and you are more likely to receive help since newer questions are monitored closely.

2. The Make Community guidelines encourages users to try to mark helpful replies as solutions to help keep the Community organized.

This marks the topic as solved, so that:

  • others can save time when catching up with the latest activity here, and
  • allows others to quickly jump to the solution if they come across the same problem

To do this, simply click the checkbox at the bottom of the post that answers your question:
Screenshot_2023-10-04_161049

3. Don’t forget to like and bookmark this topic so you can get back to it easily in future!

4. Do join the unofficial Make Discord server for live chat and video assistance

samliew – request private consultation

Join the Make Fans Discord server to chat with other makers!