Many times, connectors provide date information in formats that aren’t easily readable for end users. They contain all the necessary information that you’re looking for, but sometimes you just want the format to be more convenient.
Using the Date to String function, you can take dates you find from any of the different applications in Azuqua and convert them into a format more suitable for your needs.
By putting different combinations of specific characters in the “format” input of the Date to String function, you can create date/time outputs in any different style you’d like. I’ve included a few examples in the screenshot below.
You’ll see that the formats I used are different combinations of characters like M, D, Y, H, and more. There is a guide to how to construct these formats in the help section of the card. You can access this at any time by clicking the question mark at the bottom left of the Date to String card. Also, I’ve included the formatting below.
- D for day number (in the month) or DD to always show it using two digits
- M for month number or MM for always two digits
- MMM for three letter month name abbreviation or MMMM for full month name
- Y for four digit year number or YY for two-digit year number
- h for hour number (1-12) or hh to always show it using two digits
- H for hour number (0-23) or HH to always show it using two digits
- mm for minutes
- ss for seconds (and add S’s to include milliseconds, e.g. “ss.SSS”)
- a for “am” or “pm” or A for “AM” or “PM”
- Z for timezone in offset format (e.g. “-07:00”) or zfor code (e.g. “PDT”)
- d for day of the week (1=Monday), ddd for day abbreviation (e.g. “Mon”) or dddd for full day name (e.g. “Monday”)
Time Zone Conversion
The “zone” input on the Date to String card can be used to set the time zone of the output in case you need to change it from the default time zone that the program is giving you. I’ve included an example screenshot below.
Again, the list of accepted values for this input can be found in the help window for this card. The help documentation includes a link to the full list on Wikipedia.
If you have any questions about how these cards work or anything else you’d like us to add, just let us know here!