Mikey Posted September 8, 2021 Report Share Posted September 8, 2021 Hi, I have a triggered action and I need to have it only add a date to a field NOT the time with it.... ANY HELP would be appreciated!!! The timestamp option adds the time.. just want the current date only THANKS!!! Quote Link to comment Share on other sites More sharing options...
0 autonumber Posted September 8, 2021 Report Share Posted September 8, 2021 Hi! You can check this forum post that I have found related to getting the Date only from timestamp. Quote Link to comment Share on other sites More sharing options...
0 Mikey Posted September 8, 2021 Author Report Share Posted September 8, 2021 Hello and thank you for the response.. Those posts are if you have a date field you want to extract etc. I want a triggered action to timestamp without the time included. I tried adding a field in the table to get a "current" date with a formula but cannot do that.. Not sure where to go... Quote Link to comment Share on other sites More sharing options...
0 TellMeWhy Posted September 8, 2021 Report Share Posted September 8, 2021 1 hour ago, Mikey said: Hello and thank you for the response.. Those posts are if you have a date field you want to extract etc. I want a triggered action to timestamp without the time included. I tried adding a field in the table to get a "current" date with a formula but cannot do that.. Not sure where to go... It's manual. You will have to get current month of TimeStamp, get current day, get current year, then concatenate everything and add the '/' another way is to create a Formula Field on the Destination table and remove the time. Quote Link to comment Share on other sites More sharing options...
0 Tubby Posted September 8, 2021 Report Share Posted September 8, 2021 1 hour ago, Mikey said: Hello and thank you for the response.. Those posts are if you have a date field you want to extract etc. I want a triggered action to timestamp without the time included. I tried adding a field in the table to get a "current" date with a formula but cannot do that.. Not sure where to go... Actually, one of the comments from @autonumber's link worked for me. It is a workaround and a bit long to setup but it works just fine. It just basically makes the hours, minutes, seconds, and milliseconds to zero so that it will not show on the table once inserted. Here is a sample if it helps: You may want to try this one if it suits your preference. Quote Link to comment Share on other sites More sharing options...
Question
Mikey
Hi, I have a triggered action and I need to have it only add a date to a field NOT the time with it.... ANY HELP would be appreciated!!!
The timestamp option adds the time.. just want the current date only THANKS!!!
Link to comment
Share on other sites
4 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.