Still didn't answer the questions.

2. So, you're viewing the output in Notepad and the format of that column is YYYY/MM/DD?

4. Opening the CSV how?  Is the user opening the CSV file in Notepad?  Or are they allowing Excel to mess up the data?

I'm sorry if I couldnt answer your questions properly earlier.

1.  What is the data type of the column which is the source of your data?
     Using Current_Date so it is a DATE data type

2.  When you test that column, what does the data look like?
    In CSV the format changes to YYYY/MM/DD

3.  If you use the cast function to cast the column to date what does the data look like?
     I casted it to varchar and HTML AND EXCEL gives YYYY-MM-DD which is the desired format but users are running this report in CSV and exporting it

4.  Can you answer Doug's question.  Are you using a text editor to look at the CSV output?
     They are downloading the CSV file and opening the .CSV as is

Hi all, pleasure to have found this community.

Is anyone hiring these days? Finding roles hard to come by. I have 20+ YOE. Looking for something stable. Any leads? Let me know.

That's some deep mining, digging up a question from 16 years ago...

It looks like everybody was working really hard on this.  It's much easier.  You just need to make FM notice that a change has been made.

If your query subject expressions is...

select * from [blah]
...you just need to edit it somehow.  I usually add a space...

select *  from [blah]
Now FM knows it changed.  Click OK.

New column added.

QuoteYou are not answering the questions.

That is correct.  Still unanswered...

QuoteNot working for CSV?  Or not working for Excel?  Excel doesn't understand CSV files.  You might try looking at the result in a text editor.

Basically, if you're using Excel to open a CSV file, you're doing it wrong.
And if the requirement is to display data in Excel, use the Excel output format, not CSV.

This approach worked for me!
1. Click on Query Subject
2. Tools > Update Object

My table was indeed select * from [blah], so no concerns from me on potentially old fields being removed via the Update.

Thanks - kind of funny to find a 15 year old thread that solves my problem in 2026 :)

Quote from: bloggerman on 19 Aug 2010 03:35:38 PMI believe there is another way to it..The one mentioned above should work as well....Click on the Query Subject....Under Tools tab click the "Update Object" option and that should update the Query Subject with latest metadata information from the database. Try it out and let me know if it works.

Quote from: cognostechie on 19 Aug 2010 03:41:33 PMYes, Tools/Update Object is the right way to do it. However, keep in mind that by doing this, if any column has been deleted from the Table, it will also be deleted from the Query Subject

You are not answering the questions.  I don't know if that is because you don't understand them or not.  Your responses lack sufficient context. Please do try to answer the questions.

I'm using the current date and converting it to a varchar format. It displays correctly as YYYY-MM-DD in HTML and Excel outputs. However, when exporting to CSV, the format changes to YYYY/MM/DD, regardless of the adjustments made in the report expression.

Users rely on the CSV output as a source file for downstream imports, so they need the date to be consistently formatted without requiring any manual changes after download.

1.  What is the data type of the column which is the source of your data?
2.  When you test that column, what does the data look like?
3.  If you use the cast function to cast the column to date what does the data look like?
4.  Can you answer Doug's question.  Are you using a text editor to look at the CSV output?
 

Thanks Doug for responding on this and this is a CSV issue. I just ran below code and the CSV output is generating the Date format as 01/23/2026 instead of 2026-01-23. Users are expecting YYYY-MM-DD format in csv. Please let me know if there is any workaround this. Thanks.

Code:

cast(_year (current_date), varchar(4)) || '-' ||
substring('00' || cast(_month(current_date), varchar(2)), 1 + char_length(cast(_month(current_date), varchar(2))), 2) || '-' ||
substring('00' || cast(_day  (current_date), varchar(2)), 1 + char_length(cast(_day  (current_date), varchar(2))), 2)