Forum Discussion

UncleLewis's avatar
UncleLewis
Responsive Resident
4 years ago
Solved

Get Date As Text

Hi all,   How can I get Date from DateTime field as Text in format "YYYYMMDD"? I tried Date.ToText([mydate],[Format = "YYYYMMDD"]) Buget getting error:   Parameter Error: We couldn't convert th...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Try this:

     

    Date.ToText(Date.From([mydate]),[Format = "YYYYMMDD"])

     

    --Nate

UncleLewis's avatar
UncleLewis
Responsive Resident
4 years ago

Thanks Nate,

That is giving me an error:

Expression.Error:We cannot convert the value 0 to type Text.
Details:
Value = 0
Type = [Type]

Where mytime = 2/22/2022 9:10:31 AM

Thanks,
-w