I’m trying to create a certain number of new records in a table based on a number in another table.
For example, if the # Field in Table A is 4, then I want to create 4 new records in Table B.
Is this possible? Any idea how I’d do it with either Scri...
I am trying to add hours to a Date and Time field.
The formula I’m using is: DATEADD({Flight Date and Time},-{Time Prior},‘hour’)
I want the result to be the date and time, X hours before the original date ad time.
Flight Date and Time is a date fiel...
Ugh. Figured it out. The formatting for the dates needs to be capitalized. The following works:
{Hotel Name}&": “&DATETIME_FORMAT({Check In}, ‘MM/DD/YYYY’)&” - "&DATETIME_FORMAT({Check Out}, ‘MM/DD/YYYY’)
Still having a formatting issue though.
I have this formula: {Hotel Name}&": “&DATETIME_FORMAT({Check In}, ‘mm/dd/yyyy’)&” - "&DATETIME_FORMAT({Check Out}, ‘mm/dd/yyyy’)
And the result I’m getting is: Hotel Name: 00/Fr/yyyy - 00/Mo/yyyy
It should be:...
I kept playing with it and what I had to do was set the Flight Date and Time Field and the result field to “Use the same time zone (GMT) for all collaborators.”
My concern is that when my computer changes time zones, these times will also change. Any...
