![]() Hope this helps! Please feel free to ask any questions or shout up if you need anything else. However, if your date is actually MM/DD/YYYY then use the following (just switching %d and %m):ĭateTimeParse(,'%m/%d/%Y %I:%M:%S %p'), Note: In the date provided it's impossible to tell whether the date is MM/DD/YYYY or DD/MM/YYYY as can be either. Once we have this in a format that Alteryx can recognise and work with, we just use the DateTimeAdd() function to add -1 hours (takeaway an hour), before then wrapping all of this in the DateTimeFormat() function to get things back into your original format, that I'd imagine is your preference? The approach looks like this - I have split the 3 functions mentioned above :on to different lines to hopefully demonstrate what's going on more clearly:ĭateTimeParse(,'%d/%m/%Y %I:%M:%S %p'), ![]() My preference is to use the DateTimeParse() function within a formula expression, where we tell Alteryx the format of the incoming DateTime. ![]() Step 2: Enter the formula, enter a equal to(). Step 1: Enter the time in two separate cells. ![]() Hey Alteryx deals with DateTime in ISO format (YYYY-MM-DD HH:MM:SS) and so, in scenarios like this, where yours is coming in a different format, we first need to parse this and we can do so in a couple of ways. Here we performed each formula in an excel for your reference. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |