I'm very new to this forum so please forgive my ignorane.
I'm trying to set a field for today's date to export from a "Results" page for each line item (row).
The only way I was able to this was by adding a Calculated Field using the formula "SysDateTime()".
That said, when I view the result it's in my preferred format of MM/DD/YYY.
However, upon export to a .csv file the export gives a result of a Long Date with the format of M/D/YYYY H:MM.
Is there an easier way to do the export and with my preferred format in the .csv of just the short date (MM/DD/YYY) or a way to add to the formula to achieve my goal?
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
DRomano
I'm very new to this forum so please forgive my ignorane.
I'm trying to set a field for today's date to export from a "Results" page for each line item (row).
The only way I was able to this was by adding a Calculated Field using the formula "SysDateTime()".
That said, when I view the result it's in my preferred format of MM/DD/YYY.
However, upon export to a .csv file the export gives a result of a Long Date with the format of M/D/YYYY H:MM.
Is there an easier way to do the export and with my preferred format in the .csv of just the short date (MM/DD/YYY) or a way to add to the formula to achieve my goal?
Thanks for any help in advance.
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.