My table have a date&time column (in String format) in the contect like “4/25/2020 0:00”. I cannot use String to Date&Time because it does not have a Date format like this. Any way to abstract date from this Date&Time format?
Hi @wuyeehow , the date format drop down is not a definitive set of formats. You can overtype the value with a format of your own,
eg try
M/d/yyyy H:mm
Note I used single M, single d and single H as these are more flexible - these allow both single or 2digit values
3 Likes
Thank you, takbb. I did not even know it is editable.
2 Likes
@wuyeehow , You aren’t the first to not realise (I think it caught me out initially too) and won’t be the last. Glad it’s working for you.
@wuyeehow
There are also Modify Date and Modify Time nodes which allo you to remove date or time from field
br
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.