how to convert below dates to uniform date.
@Jules22
Hi @Jules22,
Here is how you can do it.
Hope this helps : )
hey thanksplease have a look here:
Hi @Jules22 ,
Try this. Can you run it once.
hi @atcodedog05 i still get the same error
Hi @Jules22
What data type is Next Review Date set as in your workflow?
@davidskaife, @atcodedog05 please refer, it is string
The workflow from @atcodedog05 works for me as well, but maybe make your output a Date?
Here is a slightly different way. Ideally you shouldnt be getting that error. So i am confused 😅.
hey @atcodedog05 ,even this is throwing the same error for me. idk why😅. i have downloaded what you shared and ran. do we need to be mindful of anything else?
@Jules22 at this stage please share your workflow so we can see what's happening. What version are you on?
@alexnajm please look at this. i have 2024 version
@Jules22 you have just posted the workflow from before so I am not seeing an error? Or it just works fine for me - what is your error for this version of the workflow?
At this stage, try deleting your original data and reinserting it - this is very odd behavior and you might have to bring this to Alteryx Support
thank you @binu_acs this works for me. @atcodedog05 @alexnajm thanks!
Maybe some driver or package might have got missed. That’s why ToDate(number) might not be working 😅. But ToDate(string/date) is working based on @binu_acs‘s solution.
Anyways this was a good observation and learning 😁
Happy to help : )Cheers and have a nice day!
@atcodedog05 happy to see you here
@binu_acs like wise
