Forum Discussion

Mareno_123's avatar
Mareno_123
Icon for Helper I rankHelper I
6 years ago

date format issue - not corectly in all rows

hi, i have date format column START (d. m. yyyy h:nn:ss)  and date format column END(d. m. yyyy h:nn:ss). I wanna compare them with exact but not in format (d. m. yyyy h:nn:ss) but only in  (dd/mm/y...
Need Help
luapdoniv's avatar
luapdoniv
Icon for Resolver II rankResolver II
6 years ago

After converting to only "Date" format, do some modeling steps on that column to split that by delimiter, splitting out the day, month, year and then concatening them in the required format as to dd/mm/yyyy or mm/dd/yyyy and then format the resultant column to date.

If you can share the table, can check and resolve for you.

  • Mareno_123's avatar
    Mareno_123
    Icon for Helper I rankHelper I
    6 years ago

    for me works : 

    ok Start = FORMAT(table[start].[Date];"YYYYMMDD")