Abstract date from date&time

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.