ChatGPT unable to calculate date

How To
1

If I pass ChatGPT a name of the day I want to get the date for it’s unable to do so.

This is my prompt: I event provided the answer but still cannot give the proper result:

Screenshot 2025-01-12 at 14.34.23
Screenshot 2025-01-12 at 14.34.23457×1082 64.4 KB

I have no idea why this is happening.

Is there anyone who could solve this issue?

2

Hello @Tamas_Farago,
Welcome to the community.

Your prompt looks ok.
Try Response Format as JSON and also add instructions about it on the prompt.

Then use the Parse JSON module to Parse and extract JSON as an Array.

:bulb:P.S.: Always search first, Check Make Academy. If this is helpful, Mark Best as Solutions :white_check_mark: and give :+1:
If you need expert help or have questions? Contact or comment below! :point_down:

3

or just use this formula

{{formatDate(addDays(currentDate; (5 - weekday(currentDate)) + 7); 'YYYY/MM/DD')}}

The formula calculates next Friday’s date by:

  1. weekday(currentDate) returns a number 0-6 (Sunday=0, Monday=1, …, Friday=5)
  2. (5 - weekday(currentDate)) calculates days until this week’s Friday
  3. + 7 adds another week to get next Friday
  4. addDays() adds the calculated days to the current date
  5. formatDate() formats the result as YYYY/MM/DD
1 Like
4

Hello @Tamas_Farago,
Yes, @nicon_ws is right if the next day(that you want to find) is fixed based on a given input date then use the date formula instead of spending AI tokens.