SOLVED
DateTime format
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
ppatane
8 - Asteroid
‎04-24-2023
09:27 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I am trying to get an output of dd-mm-yyyy hhmm as part of filename and the hours and minutes keep coming up 0000. I am using this formula:
"Ouput "+DateTimeFormat(DateTimeToday(),"%d-%m-%Y %H%M")+".xlsx|Sheet1". Everything except the time appears correctly.
I obviously have one little thing wrong somewhere, probably with syntax. I am a newbie, trying to master this awesome app.
Solved! Go to Solution.
Labels:
- Labels:
- Workflow
2 REPLIES 2
17 - Castor
‎04-24-2023
09:38 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @ppatane, DateTimeToday() will default to midnight as it's only 'today' - if you want a more exact timestamp where you get the hours and minutes etc then you can use DateTimeNow() like so:
"Ouput "+DateTimeFormat(DateTimeNow(),"%d-%m-%Y %H%M")+".xlsx|Sheet1"
‎04-24-2023
09:48 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Perfect! Little more than just syntax...the correct formula needed. Grazie!
![](/skins/images/2A479D0ADEFDAA8078B5B9F489A80DDD/responsive_peak/images/icon_anonymous_message.png)